select ename,salary from(select ename,salary from emp order by salary desc)

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

Question Posted / ram

Answer Posted / ram

select ename,salary from(select ename,salary from emp order by salary desc) where rownumber<6

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the maximum number of rows in sql table?

955

Is oracle sql free?

926

Which sql statement is used to return only different values?

952

What does the hierarchical profiler does?

1002

What is crud stand for?

930

explain the difference between bool, tinyint and bit. : Sql dba

936

Why trigger is used in sql?

913

Which query operators in sql is used for pattern matching?

901

What is the difference between alter trigger and drop trigger statements?

1041

Is the primary key an index?

981

How do you delete data from a table?

973

What are the different type of joins in sql?

905

What does the base_object_type column shows in the user.triggers data dictionary view?

994

how to convert numeric values to character strings? : Sql dba

1034

Does asenumerable execute the query?

982