Grouping records

[James1981]

Hi,

Is there a way in the group by clause to group records into max of three records?

i.e. there may be more than 3 records belonging to that group in the query but I only want to see the top 3.

James.

 

[swampBoogie]

select * from t q
where pkColumn in
(select top 3 pkColumn from t
where groupingColumn = q.groupingColumnd
order by orderColumn )

If that's not what you are looking for, could you be somewhat more specific. I.e. supply some sample data and the expected result.

 

[James1981]

Thanks,

this is exactly what i was looking for

James