select column_name from table_name order by column

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

Question Posted / narendra sharma

Answer Posted / narendra sharma

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

Is This Answer Correct ?

12 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the use of mysql_close()?

1024

What is text in mysql?

957

What is the latest version of mysql?

1034

In which language it is written?

1007

What are the differences between char and varchar?

1151

What is msql?

1050

Is mysql same as sql?

941

How database are managed?

1047

Is mysql written in c?

955

What is unsigned in mysql?

987

What is mysql common?

955

How do I start mysql in ubuntu?

1089

Does adding an index lock a table?

1002

Why use stored procedures in mysql?

1029

Why do gaps in sequences occur?

1033