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?
Hi kcool1,
Try this,
select top 4 * from TableName order by ColumnName Desc
Thanks,
Jai
1 Like