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 can we run batch mode in mysql?

1064

What is meant by decimal (5,2)?

1030

What is 'mysqladmin' in mysql?

1039

What are the advantages of myisam over innodb?

987

What is mysql routine?

941

What are ddl statements in mysql?

1063

Write a command with which mysql table can be repaired

949

Why is mysql popular?

891

What is mysql root?

961

How do I know if mysql is installed on windows?

926

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2128

How do I start mysql in ubuntu?

1042

Where is the mysql data directory?

948

How do I change a procedure in mysql?

1014

What is unsigned int in mysql?

944