取出表A中第31到第40记录(SQLServer,以自动增长的ID作为主键,注意:ID可能不是连续的,下列选项正确的有()

A.select top 10 * from (select top 40 * from A order by ID) order by ID desc B.select top 31 * from A order by ID C.select * from A where ID>31 and ID D.select top 10 * from A where id not in (select top 30 id from A) 此题为多项选择题。

时间:2023-11-17 17:50:26

相似题目