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

What is a session in mysql?

974

What is data in mysql?

907

What are procedures in mysql? Explain

982

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

1022

What is the difference between BLOB AND TEXT?

1154

How to dump one database for backup.

943

Can we store pdf files in mysql?

987

How to calculate the difference between two dates?

1065

What is mysql shell?

988

What is the latest version of php and mysql?

1215

What is logs in mysql?

900

What is the insert?

898

How do you stop an access query?

916

Is mysql a free database?

943

Can mongodb replace mysql?

942