how to select top 3 OR top 5 from Column

Question

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 ?

Bhuvan Pandey · Answer

superb answer @Nitin

Vandana Blogs · Answer

IT WILL WORK select top 3 namemark from std group by namemark order by mark desc

Nitin Sontakke · Answer

@Vinay It's not as simple as it is asked for. Please see the expected output.

Vinay Singh · Answer

For top 3 select top 3 * from StudenTable order by Mark desc For top 5 select top 5 * from StudenTable order by Mark desc

ketan borsdiya · Answer

Hi Lamasat Write below Query for your output SELECT * FROM ( select Name_student AS Name_studentMarks as Marks  DENSE_RANK() over(order by Marks desc) RN from students ) A where A.RN

Nitin Sontakke · Answer

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 order by 2 Hope it helps!