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

How do I disable mysql?

941

How to rename an existing table in mysql?

1035

Is mysql relational?

919

Is mysql better than oracle?

937

Can mysql handle big data?

960

How to validate email addresses in mysql?

1125

What does "i_am_a_dummy flag" do in mysql?

961

How do I select a database in mysql?

1074

How do you name a table?

901

using primary can we relate two table, with out foreign key?

2717

What is the password of mysql?

968

What port is mysql running on?

940

What is mysql shell?

990

What is the usage of ENUMs in MySQL?

1138

How can I insert images into a Mysql database?

1057