Loading

how to select top 3 OR top 5 from Column

how to select top 3 OR top 5 from Column

lamasat lamasat

10y990

Hi All

I have Table with this values

Name_student Mark

Ahmed 200

Naser 200

Tom 150

Jaber 100

Mohammad 70

Khaled 60

Radwan 50

I want to select top 3 students by Marks

lilk this

Name_student Mark

Ahmed 200

Naser 200

Tom 150

Jaber 100

how to do that ?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhuvan Pandey10y ago
superb answer @Nitin
Vandana10y ago
IT WILL WORK

select top 3 name,mark from std group by name,mark order by mark desc
Nitin Sontakke10y ago
@Vinay,
It's not as simple as it is asked for. Please see the expected output.
Vinay Singh10y ago
For top 3
select top 3 * from StudenTable order byMark desc
For top 5

select top 5 * from StudenTable order by Mark desc
ketan borsdiya10y ago
Hi Lamasat,
Write below Query for your output,
SELECT * FROM
(
select Name_student AS Name_student,Marks as Marks , DENSE_RANK() over(order by Marks desc) RN from students
) A where A.RN<4
Nitin Sontakke10y ago
It is recommended that you do it in a stored procedure. It's a two stage process. First you will need to find out the number 100. To do that try something like following:
declare @minMarks integer
select @minMarks = Min(Value)
from (
selecttop 3 Mark
from table_name
order by Mark desc
) v
Now that you have that value, second query is very simple.
select *
from table_name
where mark <= @minMarks
order by 2
Hope it helps!