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

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

Question Posted / amit bharane

Answer Posted / amit bharane

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

Is This Answer Correct ?

3 Yes

22 No

Please Help Members By Posting Answers For Below Questions

what are the drivers in mysql? : Sql dba

985

what is the command line end user interface - mysql? : Sql dba

926

which tcp/ip port does sql server run on? : Sql dba

966

What is foreign key in sql with example?

892

What is t sql used for?

974

Can we enter data in a table in design view?

913

Explain two easy sql optimizations.

963

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1062

What is meant by cursor in sql?

943

What is the syntax to add a record to a table?

1023

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1135

How is sql used in oracle?

971

How many joins in sql?

948

What is memory optimized table?

986

What is vector point function?

1005