select column_name from table_name order by column

how to find 2nd highest salary in random database salary of employer.....

Question Posted / narendra sharma

Answer Posted / narendra sharma

select column_name from table_name order by column_name
desc limit 1,1

Is This Answer Correct ?

12 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How do I find the database name in mysql?

952

What is the role of a limit in a mysql query?

1005

How do I rename a table in mysql?

974

How do I edit a trigger in mysql?

893

What are the types of database engines available in mysql?

1040

How to calculate expressions with sql statements?

1115

Explain % and _ inside like statement?

1013

What is row locking in mysql?

966

What is mysql default database?

994

What is difference between mysql and mysql workbench?

952

What are the limitations of mysql?

1047

Which is better mysql or mssql?

922

What is the maximum connection pool size?

972

What mysql -u john -p command does?

971

What is bdb (berkeleydb)?

941