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 to show all tables with 'mysql'?

952

In which format data is stored in mysql database?

956

change column name and make a unique column so we get no dupes.

913

Does adding an index lock a table?

906

I want to find out all databases starting with ‘test’, I have access to?

1107

explain GROUPBY & HAVING clause with examples.

2230

How to load data files into tables with 'mysqlimport'?

923

How do I start mysql in mysql workbench?

891

Where is the mysql config file?

929

How do I declare a variable in mysql?

873

How to return query output in html format?

878

Why we use mysql workbench?

846

Can mysql handle big data?

900

what is the procedure to configure the application of mysql?

967

What is the default port number of mysql?

892