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 you calculate the sum of any column of a table?

1048

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

940

What is the usage of ENUMs in MySQL?

1138

Write command to import an mysql file?

1039

What are the advantages of myisam over innodb?

987

Is mysql written in c?

907

What is meant by decimal (5,2)?

1030

How do I know if mysql is installed on windows?

926

What is a storage engine?

971

What is mysqli procedural?

964

How to use triggers to track changes in mysql?

878

What is myisamchk?

974

How to use count function in mysql?

935

What is delimiter $$?

974

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

2230