Question

10万条数据要查出第一和第三条,怎样写sql语句最好

Answer 1

select
top
1
*
from
table
order
by
成绩
union
select
top
1
*
from
talbe
where
id
not
in(select
top
2
id
from
table
order
by
成绩)

Answer 2

子查询
select top 1 * from
(select top 3 * from tb order by col) a order by a.col
union all
select top 1 * from
(select top 3 * from tb order by col) b order by b.col desc

Answer 3

select * from TBL where rownum in (1,3)