Print 3 highest salary

Answer Posted / ankammarao.v

select min(EmpSal) as sal3 from EmpInfo
where EmpSal in(select distinct top 3 EmpSal from Empinfo
order by EmpSal desc)

Is This Answer Correct ?    7 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

why not null is not allowed at table level

2296


What is a trigger in mysql?

554


What is definer in mysql?

514


Should I use pdo or mysqli?

478


How do I quit mysql?

494






What is field in mysql?

469


Is mariadb faster than mysql?

471


What is database url for mysql?

450


Write a query to create a database and a table?

500


write a query to mysql in safe mode and to change the root password

529


What is innodb mysql?

503


Why do we write stored procedures?

487


What is striped backup

1832


How can an index be declared in mysql?

464


How to check if a record exists in a mysql database php?

451