select project_id from tbl_project order by project

How to find out the second largest element from mysql table

Question Posted / sivsankar.ponnurangam

Answer Posted / sivsankar.ponnurangam

select project_id from tbl_project order by project_id
desc limit 2,1

Is This Answer Correct ?

21 Yes

42 No

Please Help Members By Posting Answers For Below Questions

What is a join in mysql?

957

Is mysql connect deprecated?

1017

What are the differences between a primary key and foreign key?

1157

How to delete an existing column in a table?

1006

What is clob datatype?

942

What is a tinyint in mysql?

962

What's the latest version of mysql?

1019

What can I do with mysql?

981

How do I find mysql location?

1009

Why we use mysql workbench?

953

What does blob mean in mysql?

1014

What is flush privileges in mysql?

1046

What is data directory in mysql?

1057

How many columns can be used for creating Index?

1100

why not null is not allowed at table level

2807