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

How to calculate expressions with sql statements?

490


In which language it is written?

518


What is longblob in mysql?

523


Is mysql a backend?

514


What is insert query in mysql?

471






Does mysql automatically index foreign keys?

487


How can you handle the –secure-file-priv in mysql?

504


How do I start and stop mysql server?

470


What happens if you no create privilege in a database?

555


How to get a list of indexes of an existing table?

523


Does adding an index lock a table?

485


How to write date and time literals?

542


How to use like conditions?

542


What port is mysql running on?

476


Is oracle mysql free?

470