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

What are the technical features of MySQL?

1011

How do I edit a stored procedure in mysql?

921

How to show table structure mysql?

1007

Is number a datatype in mysql?

944

What is the command line end user interface - mysql?

1081

Does mysql support sequence?

940

Can we store files in mysql?

912

Can we join 3 tables in mysql?

952

How do I change directories in mysql?

908

How to rename an existing table in mysql?

1031

What is meant by sharding?

924

How do I automate a backup in mysql?

988

What is the difference between char and varchar in mysql?

1114

List data types in mysql? Explain

918

How do I select a database in mysql?

1069