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

Can you rename a database in mysql?

991

How important is to list the column names when doing an insert?

1023

What is timestamp in mysql?

973

Where is mysql password stored?

912

How can we convert between Unix & MySQL timestamps?

941

How does mysql store data?

917

Is mysql owned by oracle?

990

change column name and make a unique column so we get no dupes.

960

How to present a past time in hours, minutes and seconds?

1028

What is the use of mysql_close()?

962

How do I copy a table in mysql workbench?

858

What is data type for image in mysql?

848

Explain triggers and stored procedures?

902

What is mysql57?

891

How many mysql connections can handle?

877