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 are the applications required to support mysql?

1004

What is memory table in mysql?

996

How to include numeric values in sql statements?

1060

What is procedure in mysql?

984

Explain the difference between mysql and mysql interfaces in php?

1164

What are the differences between innodb and myisam engines?

1041

Can I use mysql for free?

944

How much does mysql enterprise cost?

977

What is the difference between mysql and sql?

1107

What is mysql vs sql?

1042

How can I connect mysql database?

944

What is trigger in mysql?

983

What are the functions in mysql?

1009

What does mysqli stand for?

993

What is a table schema?

1044