Write a query to find five highest salaries from EMP table. (there is a column

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / lmeher.tcs

Answers were Sorted based on User's Feedback

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

Answer / mohammad murtuza ali

select * from salary where rowno<6

Is This Answer Correct ?

4 Yes

15 No

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

Answer / amit bharane

select salary from employees
where rownum<=5
order by salary desc

Is This Answer Correct ?

3 Yes

22 No

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

Answer / mohammad murtuza ali

select * from SALARY where where rowno<6 and empname like
empname

Is This Answer Correct ?

2 Yes

29 No

Write a query to find five highest salaries from EMP table. (there is a column SALARY)..

Answer / sujith

select * from test_sujith where rownum < 6 order by item3 desc

Is This Answer Correct ?

2 Yes

31 No