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 to dump a table from a database.

967

How to run a sql statement?

977

can you tell what are the different set operations available in mysql? : Mysql dba

851

How do I show all mysql databases?

930

What you can use regular expression for in mysql?

889

How to show table structure mysql?

949

What is slow query log in mysql?

1044

How many sql dml commands are supported by 'mysql'?

918

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

925

What are the technical features of MySQL?

964

How do you connect MySQL database with PHP?

934

How do I show users in mysql?

997

What is the use of procedure in mysql?

895

What is trigger in mysql?

884

How do I delete a row in mysql?

901