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 is mysql in linux?

952

How do you rename a table?

935

How do you create a table in mysql workbench?

864

What is the datatype for password in mysql?

924

what are the different tables present in mysql? : Mysql dba

929

What is row level locking in access?

830

What causes mysql too many connections?

876

How do I disable mysql?

873

Which is better mysql or mssql?

861

How do I run a query in mysql?

894

What is the usage of ENUMs in MySQL?

1064

What is limit in mysql?

824

How is oracle different from mysql?

932

What is memory table?

853

How to get data from mysql in php?

837