limiting resules from a query

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

This is my problem. I have a pile of item data from 25
different groups. I want the top 10 out of >10 by each
group. Anyone have any suggestions?

Thanks,

Brad
 
Your query should go somethine like this
select distinct Top 10 Valuefield, valuename
FROM tablename
Order By Valuefield

Jim
-----Original Message-----
This is my problem. I have a pile of item data from 25
different groups. I want the top 10 out of >10 by each
group. Anyone have any suggestions?

Thanks,

Brad
.
SELECT DISTINCT TOP 10 ModelPrice, ModelName
Click to expand...
FROM tblModels
ORDER BY ModelPrice DESC;
 
Back
Top