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

How do I copy an entire mysql database?

945

What is RMS Migrations

2444

What is meant by mysqli?

956

How do I download mysql on my laptop?

948

How do I declare a variable in mysql?

1012

What are mysql functions?

997

What is max_used_connections in mysql?

992

What is mysql primary key?

1020

What is mysql optimization?

968

What is bigint in mysql?

974

What is logs in mysql?

951

What is save point in mysql?

1003

What are the technical features of MySQL?

1066

Is mysql a nosql database?

1214

how can you test for null values in a database? : Mysql dba

981