select id from tbl_name order by id desc limit(1,1) (selects 2nd highest

How to find out the second largest element from mysql table

Question Posted / prasad

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What are all the Common SQL Function?

1104

How do you restart mysql?

892

What is meant by sharding?

910

What are the 5 r's of managing behaviors?

1064

what is cte? : Mysql dba

930

What is the difference between the LIKE and REGEXP operators?

1014

What is definer in mysql?

941

How can you plan the logshipping before processing?

2312

What are triggers in mysql?

909

How can you filter the duplicate data while retrieving records from the table?

881

What does do in mysql?

857

How show all tables in mysql query?

902

What is default password for mysql?

849

What are the technical features of MySQL?

997

What is a delimiter in mysql?

1002