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 |
Does mysql use tcp or udp?
What storage engines are used in MySQL?
What are procedures in mysql? Explain
Can I use mariadb instead of mysql?
What is the use of ENUM in MySQL?
What is data type for image in mysql?
What is maximum table size in mysql?
Why use stored procedures in mysql?
How many columns can you create for an index?
What is int mysql?
What are the drivers in MySQL?
How do I enable mysqli extension?