TOP 95 Percent Query

[PCarra]

I am trying to query for the TOP 95 records for a group of records of Devices. I am using the query below:

SELECT TOP 95 PERCENT [Utilization BPS], [Device]
FROM testQuery1
ORDER BY [Utilization BPS], [Device];

This query returns the top 95 records for device 1 and 2. I want it to return the top 95 records for each device. Can anyone help lead me down the right path?

Thanks in advance for the help!

[June7]

Review http://allenbrowne.com/subquery-01.html#TopN

[PCarra]

June7 thank you I was able to work with that and get what I was looking for!