Try this:
SELECT PERSON, MONTH, COUNT
FROM ( SELECT
PERSON,
MONTH,
COUNT,
ROW_NUMBER() OVER (PARTITION BY MONTH ORDER BY COUNT DESC) RN
FROM TABLEA
)
WHERE RN <= 3
ORDER BY 2,1 ;
Tamil
|
Results 1 to 2 of 2
Thread: SQL HelpThreaded View
|
Click Here to Expand Forum to Full Width |