Question

这条SQL语句该怎么写

这条SQL语句该怎么写

拿来分页的。“ps=ct.prepareStatement("select top "+pageSize+" * from users where userId not in (select top "+pageSize*(pageNow-1)+" userId from users)");”
这条是正确的，我要改一下。改成查询users表中的，name列。可是为什么提示not附近有语法错误？麻烦大家看看哈。作业
ps=ct.prepareStatement("select top "+pageSize+" * from users where username='"+name+"' not in (select top "+pageSize*(pageNow-1)+" '"+name+"' from users)");
呵呵 。谢谢1楼的。
结果出来了，正确的是ps=ct.prepareStatement("select top 10 * from users where username='"+name+"' and username not in (select top "+pageSize*(pageNow-1)+" '"+name+"' from users)");

Answer 1

ps=ct.prepareStatement("select top "+pageSize+" * from users where username='"+name+"' and username not in (select top "+pageSize*(pageNow-1)+" '"+name+"' from users)");
试下看
username='"+name+"' not in这里语法不完整，要改为username='"+name+"' and username not in

Answer 2

where username='"+name+"' not in 这里错了
username既然已经等于name了 not in要给一个字段
这样写 where username='"+name+"' and username not in

Answer 3

一楼正解

Answer 4

select top 20 * from users where username='test' and username not in (select top 10 'test' from users)
username=***之后要加上"and"才可以，这是两个条件，不能写在一起