Hello,
I'm trying to grab the top 10 percent from each ID from a table in a select query. And for some reason it is only grabbing the top 10 percent of like 4 of the ID's..Idk why. Here is the code:
SELECT TOP 10 PERCENT [Table1].*
FROM Table1
ORDER BY [Templates], [ID];