oracle sql top 1

工作需要查詢每個種類的第一筆資料

oracle沒有提供top n功能，但是有提供rownum做類似的功能

這個寫法要用子查詢

SELECT * FROM  
(SELECT ID, TYPE, STATUS FROM A WHERE STATUS = 'Y' AND TYPE = 'xxx' ORDER BY ID DESC)  
WHERE ROWNUM <=1;

SELECT * FROM

(SELECT ID, TYPE, STATUS FROM A WHERE STATUS = 'Y' AND TYPE = 'xxx' ORDER BY ID DESC)

WHERE ROWNUM <=1;

Wen's murmur