select distinct column_name from table_name order by column

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

Question Posted / arnab das

Answer Posted / arnab das

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

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How is oracle different from mysql?

1029

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

932

What are date and time functions in mysql?

1014

What is the difference between having and where clause in mysql? Explain

1021

How do I update a variable in mysql?

944

How do you create a new database in mysql?

919

How does select query work?

946

Can you tell how to find the number of rows in a resultset using php?

904

Explain Access Control Lists.

996

How to dump one database for backup.

947

What is mysql default database?

1008

How many groups of data types?

988

Write a program using the select statement, while loop.

915

How to delete a trigger in mysql?

930

Is mysql owned by oracle?

1021