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

4 Answers
7103 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can you rename a database in mysql?

948

Explain % and _ inside like statement?

949

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

3117

How does mysql store binary data?

893

How to create a table index in mysql?

893

What is a data directory?

874

What is max connections in mysql?

874

How to use case expression?

896

What happens if you no create privilege in a database?

1027

Is sql similar to mysql?

820

Is mariadb faster than mysql?

903

Do I need python for mysql?

865

How do I start mysql in linux?

838

What does blob mean in mysql?

907

What is mysql data directory?

920