TOP 5 Percent Grouped

[thefox149]

I have record in a table

Month Group Value

what i would like to do is find the top 5 percent value per month per group ..

the Top 5 Percent only bings back the TOP 5 Percent record count in the table eg top 5 record in a table of 100

 

[ByteMyzer]

You might try something along these lines:

SELECT T1.*
FROM MyTable T1
WHERE T1.Value In
(SELECT TOP 5 PERCENT T2.Value
 FROM MyTable T2
 WHERE T2.Month=T1.Month AND T2.Group=T1.Group
 ORDER BY T2.Value;)
;