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 horizontally scalable?

990

Write a query to display even rows in student table using mysql?

903

Is mysql good for big data?

949

Does mysql automatically index foreign keys?

935

What mysql -u john -p command does?

981

How many columns can a mysql table have?

915

What is difference between oracle sql and mysql?

1025

What does innodb stand for?

978

What is a deterministic function?

1076

What is triggers?

967

Is Mysql query is case sensitive?

1029

What is mysql sleep process?

1039

How would you get the current date in mysql?

1112

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

952

Where the database is stored in mysql?

973