求列的第一个值

求第一个值

select * from (select * from table order by key) where rownum=1;

求最后一个值

select * from (select * from table order by key desc) where rownum=1;

sqlserver

select top 1 xx from xxx;

mysql

select * from xxx limit 1