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

How to find out the second largest element from mysql table

Question Posted / prasadkonnur

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

Please Help Members By Posting Answers For Below Questions

What is mysql default port number?

962

What are the functions used to encrypt and decrypt the data present in mysql?

1010

What is insert query in mysql?

842

What is difference between mysql and mysql workbench?

874

What are the three types of queries?

846

What is difference between mysql and mysqli?

863

What is mysqli_connect_error ()?

967

What does mysql workbench do?

809

How to update info already in a table and delete a row(s) from a table.

815

How do I run a query in mysql?

893

How is mysql database stored?

1005

What is meant by sharding?

864

How do you backup a database in mysql?

1006

Why do gaps in sequences occur?

891

What are date and time intervals?

921