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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you select a table?

694


What is join in mysql? What are the different types of join?

709


What is the use of pdo?

724


Describe mysql transaction properties.

724


How do I download mysql on my laptop?

668


What is foreign key in mysql?

795


What is the data type for file in mysql?

734


How many columns can a mysql table have?

673


what is constraints? Also explain the different types of constraints?

720


List some mysql advantages and disadvantages?

728


What is mysql database server?

669


How to get last inserted id after insert data from a table in mysql?

758


What are the similarities between a function and a procedure?

666


Which is better sqlite or mysql?

721


Is mysql still popular?

670