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 you restart mysql?

868

How to Change a users password from unix shell.

1049

How do I install and use mysql?

900

What is the insert?

850

How to include comments in sql statements?

919

Is number a datatype in mysql?

907

What are the functions of mysql?

902

can you tell what are the different set operations available in mysql? : Mysql dba

855

How do you concatenate strings in mysql?

963

How to include character strings in sql statements?

933

How to run a sql statement?

983

What is difference between mysql and mysqli?

886

What is data node in mysql cluster?

953

How can you count the total number of records of any table?

886

What language does mysql use?

845