Print 3 highest salary

Answer Posted / priya

select top 1 salary from ( select top 3 salary from ( select
distinct salary from employee order by desc ) order by asc);

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the datatype for password in mysql?

519


How large can a mysql table be?

456


What is back end and front end?

463


Can you tell the difference between $message and $$message?

527


What is blob and text in mysql?

609






explain GROUPBY & HAVING clause with examples.

1830


what is the difference between gui testing and database testing? : Mysql dba

521


Can you shard mysql?

497


How do I transfer data from one database to another in mysql?

493


What is a scalar function?

526


How many columns is too many mysql?

471


What is identity in mysql?

503


What you can use regular expression for in mysql?

486


How do I select a database in mysql?

491


What are the two types of queries?

445