sql 达人指点一上异常句_Sql Server

sql 达人指点一下错误句

SQL code

SELECT TOP 10 * FROM table WHERE name LIKE '$k%' AND id NOT IN(SELECT TOP 10 id FROM table WHERE name LIKE '$k%' ORDER BY LEFT(ltrim(name),1) ORDER BY uptime DESC)

想要先按照更新时间uptime倒序查询然后分页
不知道哪里有问题

------解决方案--------------------

SQL code

SELECT TOP 10 * FROM table WHERE name LIKE '$k%' AND id NOT IN(SELECT TOP 10 id FROM table WHERE name LIKE '$k%' ORDER BY LEFT(ltrim(name),1)) ORDER BY uptime DESC
------解决方案--------------------
SQL codeSELECT TOP 10 * FROM table WHERE name LIKE '$k%' AND id NOT IN(SELECT TOP 10 id FROM table WHERE name LIKE '$k%' ORDER BY LEFT(ltrim(name),1),uptime DESC)
------解决方案--------------------
SQL codeSELECT TOP 10 * FROM table WHERE name LIKE '$k%' AND id NOT IN(SELECT TOP 10 id FROM table WHERE name LIKE '$k%' ORDER BY LEFT(ltrim(name),1),uptime DESC)
------解决方案--------------------
探讨

谢谢上面几位 现在去掉一个order by 不报错了  但是因为我还一个条件是匹配度  现在查出来的还是按照匹配度的排列结果  没有按照更新时间。。。