Display top 5 marks in mysql without limits

Question

Display top 5 marks in mysql without using limits.

Pankaj Kumar Choudhary · Answer

Hello Murugappan Try this Select Tab.Salary From (SELECT Employee .Salary, @curRank := @curRank + 1 AS rank FROM Employee , (SELECT @curRank := 0) r Order By Employee.Salary DESC )Tab Where Tab.rank

Rajeev Punhani · Answer

Hi Murugappan, Please check the following query SET @row_number = 0; SET @row_number1 = 0; SELECT DISTINCT(salary) FROM ( SELECT DISTINCT(salary),(@row_number1:=@row_number1 + 1) FROM( SELECT total_bill,(@row_number:=@row_number + 1) AS num FROM tablename WHERE @row_number )a WHERE @row_number1 ) b If the above solution is helpful then, accept the answer.

Rajeev Punhani · Answer

Hi Murugappan, Please try the following query. SET @row_number = 0; SELECT *, (@row_number:=@row_number + 1) AS num FROM tablename WHERE @row_number If the above solution is helpful then, accept the answer.

Pankaj Kumar Choudhary · Answer

Hello @Murugappan try this query Select tab.Marks From (SELECT p.Marks, @curRank := @curRank + 1 AS rank FROM tTable-Name p, (SELECT @curRank := 0) r)Tab Where Tab.rank

Murugappan Mn · Answer

I came across another code select * from Employee e1 where 5>(select count(distinct(e2.salary)) from Employee e2 where e2.salary> e1.salary) order by salary desc;

Murugappan Mn · Answer

Thank you Rajeev, your code also worked for me...

Murugappan Mn · Answer

I'm not getting it I have table with name Employee, columns-Id,Name and Salary.I have to show top 5 salary(we have to use order by desc)

Pankaj Kumar Choudhary · Answer

Try This Select Tab.col1 From (SELECT *, @curRank := @curRank + 1 AS rank FROM table_ p, (SELECT @curRank := 0) r)Tab Where Tab.rank Order BY Tab.col1

Murugappan Mn · Answer

This one is showing first 6 records(if we use less than it will be solved).I need to show top 5 salaries. So, I have to use order by then use this code.Do you have any idea how to do that

Cassie Mod · Answer

use something like this: select MAX('columnname') from table order by value desc limit N

Display top 5 marks in mysql without limits

Answers (10)