当前位置：首页 -> 面试

经典sql语句面试题(二)

2014-11-14 13:00:04 · 作者: · 浏览: 53
标签: 经典 sql 语句 试题
lect max(ID) from (select top 30 ID from A order by ID ) T) order by ID
方法二：
select top 10 *
from A
where ID not In (select top 30 ID from A order by ID)
order by ID