sql 取前几行记录语句

select * from tab fetch first 10 rows only

select * from tab where rownum <=10

select top 10 * from tab

SELECT * FROM tmp_Trans t
WHERE ID IN(
 SELECT TOP 2 ID
 FROM tmp_Trans
 WHERE PO_NO=t.PO_NO
 ORDER BY Trans_Date DESC
)

SELECT *
FROM tmp_Trans t
WHERE (
 SELECT COUNT(*)
 FROM tmp_Trans
 WHERE PO_NO=t.PO_NO AND Trans_Date>T.Trans_Date
)<2

SELECT DISTINCT b.*
FROM tmp_Trans a
CROSS APPLY
(
 SELECT TOP(2) * FROM tmp_Trans WHERE a.PO_NO=PO_NO ORDER BY Trans_Date DESC
) b

select * from (
 select ROW_NUMBER() OVER(PARTITION BY PO_NO ORDER BY Trans_Date DESC) as rowid,*
 from tmp_Trans
) a
where rowid<=2

select * from tab limit 10

select table_name from t_tables where rownum<2 order by table_name desc;

select t2.* from (select * from t_tables t order by table_name desc) t2 where rownum<2