查询出的结果为排名最高的和排名最低的sql

[ozn_switch]

假设有这么一个表detail:
字段为: name rank
记录为: tom 1
jery 3
jim 2
li 4
.
.
.
name就是名字了，rank是个排名，现在想查询出的结果为排名最高的和排名最低的name.
如果这么写：select s1.*, s2.* from
(
(select t1.name from
(select name from rank order by rank) t1
where rownum = 1)
) s1,
(
(select t2.name from
(select name from rank order by rank desc) t2
where rownum = 2)
) s2
势必效率不高，请教高手更好的写法，谢谢

[heyixiang]

下面的代码效率应该更高些

select * from detail where rank in (select max(rank) from detail)
union all
select * from detail where rank in (select min(rank) from detail)

[ozn_switch]

谢谢
一会我就结帖

[ozn_switch]

好不容易找到结帖的地方。。。

[bjt_]

记录数少，用子查询，rank要有索引，
select * from detail where rank in
(select max(rank) from detail
union select min(rank) from detail)

[ozn_switch]

哦，谢谢bjt_
用union来连接，我没想到。
如果记录数比较多呢