sql 达人指点一上异常句

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)

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 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),uptime DESC)
[解决办法]
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),uptime DESC)
[解决办法]
探讨


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