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-IdName 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