select * from (select a.* from employees a order by a.salary desc) wher

Print 3 highest salary

Question Posted / m gangadhar

Answer Posted / m gangadhar

select * from (select a.* from employees a order by
a.salary desc) where rownum <= 5

Is This Answer Correct ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the data source name for mysql?

484

How to use triggers to track changes in mysql?

489

How can you move the master database

1525

What are mysql functions?

497

What is datadir?

482

What is query design?

473

What is federated tables in mysql?

474

What is mysql routine?

472

How to include numeric values in sql statements?

506

What is relational database in mysql?

500

How to get data from mysql in php?

438

what are the different tables present in mysql? : Mysql dba

472

Is mysql port 3306 tcp or udp?

521

How to use mysqldump to create a copy of the database?

509

Is mysql free for commercial use?

479