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

What is the difference between procedure and function in mysql?

954

What is mysql architecture?

955

What is the purpose of mysql database?

875

What is a simple query?

842

What causes mysql too many connections?

875

What is difference between pdo and mysqli?

913

Is mysqli faster than mysql?

863

Can I use mysql for free?

836

How many groups of data types?

927

What is prepare statement in mysql?

920

What is sql vs mysql?

960

What is unsigned int in mysql?

870

If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

890

What is the difference between timestamp and datetime in mysql?

975

What is query log in mysql?

899