Top-N, Rank() and Partition

To get Top-N, and rank; Can do this:


SELECT * FROM
(
SELECT b.ap_prog_code, b.dealer_code, b.no_of_outlets, b.trans_Date,
rank() OVER
(
PARTITION BY b.ap_prog_code, b.dealer_code
ORDER BY trans_Date DESC
) rank_date
FROM OUTLET b
)
WHERE rank_date = 1