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

How can I see all mysql databases?

939

In mysql, what is joins? Explain

1027

What are the other commands to know the structure of a table using mysql commands except explain command?

1092

What's the difference between mysql and sql server?

1038

What is the difference between procedure and function in mysql?

1072

what is the procedure to configure the application of mysql?

1093

How to create trigger in mysql workbench?

1036

What is action query?

946

How do I show all mysql databases?

1019

What does the file with the extension: frm, myd, and myi contain?

984

How large can a mysql table be?

1013

How to control the max size of a heap table?

1045

Why do gaps in sequences occur?

1033

What is mysql common?

955

Why we use mongodb instead of mysql?

1018