select * from tablename where colname=(select max(colname) from tablename);
select * from tablename where colname=(select min(colname) from tablename);
select * from tablename where colname=(select min(colname) from tablename);
union all
select * from (select top 1 * from table8 order by 数值) b
union
select * from (select a.*,rank() over(order by 数值) rk from tab a) where rk=1
oracle 是不支持top 语句的.
还是beckhambobo的办法比较好.