查询表的首句:(Oracle)
select * from (select a.*, rownum as rn from tab_name a order by col )where rn = 1
or
select * from tab_name where rownum = 1
sqlserver
Select TOP 1 * from 表
查询表的首句:(Oracle)
select * from (select a.*, rownum as rn from tab_name a order by col )where rn = 1
or
select * from tab_name where rownum = 1
sqlserver
Select TOP 1 * from 表
转载于:https://www.cnblogs.com/huangwentian/p/10423572.html