请教各位一个SQL语句的问题

问题是这样的：
SELECT *
FROM businessinfo AS a
WHERE a.classID="10" and a.infoID NOT IN (SELECT TOP 1 infoID FROM businessinfo order by pubtime desc);
我想把数据库表格classid为10 并且按照pubtime排序后除了最新添加的那条记录之外 再选择出来
我上面写的这条数据库SQL语句还是把最新添加的那条记录给选择出来了 真是挺奇怪
请各位帮忙看看是哪里写错了啊 谢谢各位了

SELECT *
FROM businessinfo a
WHERE a.classID="10" and a.infoID NOT IN (SELECT TOP 1 infoID FROM businessinfo where classID = a.classID order by pubtime desc);