I have a somewhat basic query, lets say its like this
select top 20 onefield, twofield, three field
from my table
This returns twenty records.
There are three types of values in onefield, I want to see the top twenty for each i.e. returning 60 rows.
Can't figure it out?
select top 20 onefield, twofield, three field
from my table
This returns twenty records.
There are three types of values in onefield, I want to see the top twenty for each i.e. returning 60 rows.
Can't figure it out?