select ename,sal,SAlrank from(select ename,sal,dense

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

Question Posted / sarath

Answer Posted / sarath

select ename,sal,SAlrank from(select ename,sal,dense_rank()
over(order by sal desc) Salrank from emp)
where salrank <=5

Is This Answer Correct ?

9 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is trigger in sql? Explain

941

What is an exception in PL/SQL? What are the two types of exceptions?

1192

what is 'mysqladmin' in mysql? : Sql dba

972

How many commands are there in sql?

971

Is time a data type in sql?

852

How to rename a column in the output of sql query?

1000

What is the difference between numeric and autonumber?

939

Explain the difference between 'between' & 'and' operators in sql

945

What are different functions in sql?

897

What is the primary use of normalization?

941

Can we call stored procedure in function?

903

How do I run a sql query?

968

What is cursor explain with example?

922

Is sqlite good enough for production?

948

What does select top 1 do in sql?

1000