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

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1173

How do I enable mysqli extension?

1068

how to connect a php script with the mysql database?

1121

Is mysql easy to learn?

981

How do I view data in mysql workbench?

1068

What are the objects can be created using CREATE statement?

1038

Can foreign key have duplicate values?

943

Where MyISAM table will be stored and also give their formats of storage?

1110

How do you insert a table?

971

Which is better mysql or microsoft sql?

978

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

1047

What is use of mysql?

984

Write a query to fetch common records between two tables using mysql?

1071

What is pdo in mysql?

972

Write a query to fetch duplicate records from a table using mysql?

991