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
10 October 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment