帮我看下
错误发生在:SELECT TOP 12 * FROM (select count(number) as t,number from yy where createtime>='2009-05-01 00:00:00' and createtime<='2009-05-14 23:59:59' group by number order by t desc) WHERE number NOT IN (SELECT TOP 0 number FROM (select count(number) as t,number from yy where createtime>='2009-05-01 00:00:00' and createtime<='2009-05-14 23:59:59' group by number order by t desc) where createtime>='2009-05-01 00:00:00' and createtime<='2009-05-14 23:59:59' group by number order by count(number) desc ) and createtime>='2009-05-01 00:00:00' and createtime<='2009-05-14 23:59:59' group by number order by t desc;java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]除非同时指定了 TOP,否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。
怎么修改呀
急~~
错误发生在:SELECT TOP 12 * FROM (select count(number) as t,number from yy where createtime>='2009-05-01 00:00:00' and createtime<='2009-05-14 23:59:59' group by number order by t desc) WHERE number NOT IN (SELECT TOP 0 number FROM (select count(number) as t,number from yy where createtime>='2009-05-01 00:00:00' and createtime<='2009-05-14 23:59:59' group by number order by t desc) where createtime>='2009-05-01 00:00:00' and createtime<='2009-05-14 23:59:59' group by number order by count(number) desc ) and createtime>='2009-05-01 00:00:00' and createtime<='2009-05-14 23:59:59' group by number order by t desc;java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]除非同时指定了 TOP,否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。
怎么修改呀
急~~
SELECT TOP 12 * FROM (select count(number) as t,number from yy where createtime>='2009-05-01 00:00:00' and createtime <='2009-05-14 23:59:59' group by number ) T
WHERE number NOT IN
(SELECT TOP 0 number FROM (select count(number) as t,number from yy where createtime>='2009-05-01 00:00:00' and createtime <='2009-05-14 23:59:59' group by number)T
where createtime>='2009-05-01 00:00:00' and createtime <='2009-05-14 23:59:59' group by number order by count(number) desc ) and createtime>='2009-05-01 00:00:00' and createtime <='2009-05-14 23:59:59' group by number order by t desc