你的SQL语句的字段 或表名都与 SQL里面的关键字重合 要改下名字: 象下面这样: select top 1 I1D from USER1 where NAME1='YES' and ID1 not in ( select top 10 ID1 from USER1 where NAME1='YES' order by ID1 ) order by ID1
select top 1 I1D from USER1 --第一句 --------------------- 改为: select top 1 ID1 from USER1
没有问题呢,我按照楼主的思路建表查询没问题啊。或许楼主试着把表建在另外一个数据库里再试试。或者重新命名表名,字段,查询一次。 select top 1 id from test where name='yes' and id not in (select top 3 id from test where name='yes' order by id desc) order by id asc
要改下名字:
象下面这样:
select top 1 I1D from USER1
where NAME1='YES' and ID1 not in
(
select top 10 ID1 from USER1
where NAME1='YES'
order by ID1
) order by ID1
---------------------
改为: select top 1 ID1 from USER1
select top 1 id from test where name='yes' and id not in
(select top 3 id from test where name='yes' order by id desc)
order by id asc