SQLTeam.com | Weblogs | Forums

SQL query for select maximum 4


#1

Hey all i am new here so i do not know if this is the correct place to post this, but here goes.
How do i select the maximum 4 values in a table? Lets say i have these 7 values, 2,4,1,5,7,8,3, i want to select the top 4 maximum , 8,7,5,4.
How would i go about doing so?
I know MAX() selects the Maximum of the whole list, but how about 4 maximums?


#2

Hi kcool1,

Try this,

select top 4 * from TableName order by ColumnName Desc

Thanks,
Jai