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

How to use like conditions?

548


What is the hostname for mysql database?

475


What is select query in mysql?

471


Is mysql a odbc?

475


How many rows can mysql hold?

471






How can you filter the duplicate data while retrieving records from the table?

478


Is mysql a good database?

499


How to create a table index in mysql?

528


Is mysql relational?

511


How do I import database through command line?

502


What is the difference between mysql_fetch_assoc and mysql_fetch_array?

457


What is triggers and how it can be used in mysql?

531


What is triggers?

514


What is pdo mysql?

511


What is the use of mysqli_fetch_assoc?

492