子查询要有别名,如:select top 3 * from (select * from users where userName='admin') awhere userId not in (select top 0 userId from (select * from users where userName='admin') b)