How to find out the second largest element from mysql table

Categories >> Software >> Databases >> MySQL
Suggest New Category

Question Posted / rakesh kumar nautiyal

15 Answers
28497 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to find out the second largest element from mysql table..

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

How to find out the second largest element from mysql table..

Answer / nikhil mishra

SELECT Salary FROM tablename order by Salary desc limit 1,1

Is This Answer Correct ?

24 Yes

11 No

How to find out the second largest element from mysql table..

Answer / lekhraj deshmukh

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

How to find out the second largest element from mysql table..

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

How to find out the second largest element from mysql table..

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

How to find out the second largest element from mysql table..

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

How to find out the second largest element from mysql table..

Answer / ved prakash bishnoi

select salary from tableName group by salary order by
salary limit 2,1

Is This Answer Correct ?

10 Yes

10 No

How to find out the second largest element from mysql table..

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

How to find out the second largest element from mysql table..

Answer / prasad

select id from tbl_name order by id desc limit(1,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 ?

5 Yes

5 No

How to find out the second largest element from mysql table..

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

Post New Answer