How to find out the second largest element from mysql table
Answers were Sorted based on User's Feedback
Answer / laxmanit08
select final_id from care_billing_final order by final_id
desc limit 1,1;
Is This Answer Correct ? | 49 Yes | 14 No |
Answer / nikhil mishra
SELECT Salary FROM tablename order by Salary desc limit 1,1
Is This Answer Correct ? | 24 Yes | 11 No |
select marks from tbl_data where marks<(select max(marks)
from tbl_data) order by marks desc limit 1;
Is This Answer Correct ? | 21 Yes | 11 No |
Answer / prasadkonnur
select id from tbl_name order by id desc limit(0,1)
(selects 2nd highest id)
for nth highest
select id from tbl_name order by id desc limit(n-1,1)
Is This Answer Correct ? | 13 Yes | 10 No |
Answer / deo ram yadav
select BranchName
from Account
order by Balance desc limit 1, 1;
Note: ,BranchName' is attribute and 'Account' is table. 1,1 means leave one row and then take another one row.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / md aftab alam
select distinct final_id from care_billing_final order by final_id
desc limit 1,1;
Is This Answer Correct ? | 2 Yes | 1 No |
select salary from tableName group by salary order by
salary limit 2,1
Is This Answer Correct ? | 10 Yes | 10 No |
Answer / salil
SELECT max( t1.col )
FROM `table` t1
WHERE t1.col < (SELECT max( t2.col ) FROM `table` t2);
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / prashant chaudhary
select name,marks from Student_Info where marks = (select
max(marks) from Student_Info where marks <
(select max(marks)from Student_Info ))
Is This Answer Correct ? | 4 Yes | 4 No |
How to see the database architecture in MySQL??
How will you export tables as an xml file in mysql?
How to show table names with 'mysqlshow'?
what is JOIN? Give example & types of join?
14 Answers iMedia, Millennium, RAM Software, Satyam,
Explain multi-version concurrency control in MySQL?
How do I uninstall mysql connector?
How do I copy a table in mysql workbench?
How do I completely remove mysql from windows?
How do you change a password for an existing user via mysqladmin?
What is the function of myisamchk?
How to use rank function in mysql?
How to use case expression?