Display top 5 marks in mysql without limits

Murugappan Mn

10y1.2kSQL

Display top 5 marks in mysql without using limits.

10 Replies

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

Pankaj Kumar Choudhary10y ago
Accepted 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<5

+1
Murugappan Mn10y ago
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;
0
Murugappan Mn10y ago
Thank you Rajeev, your code also worked for me...
0
Rajeev Punhani10y ago
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<=5 ORDER BY salary DESC
)a WHERE @row_number1<=5
) b
If the above solution is helpful then,accept the answer.
+1
Murugappan Mn10y ago
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)
0
Pankaj Kumar Choudhary10y ago
Try This

Select Tab.col1 From
(SELECT *, @curRank := @curRank + 1 AS rank FROM table_ p, (SELECT @curRank := 0) r)Tab
Where Tab.rank<5
Order BY Tab.col1
0
Murugappan Mn10y ago
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
0
Rajeev Punhani10y ago
Hi Murugappan,

Please try the following query.

SET @row_number = 0;
SELECT *,(@row_number:=@row_number + 1) AS num FROM tablename WHERE @row_number<=5

If the above solution is helpful then,accept the answer.

+1
Pankaj Kumar Choudhary10y ago
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<=5;
+1
Cassie Mod10y ago
use something like this:

select MAX('columnname') from table order by value desc limit N
0