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 does t sql mean?

951

Is sql workbench free?

1006

What is parallel hint?

1333

Mention what plvcmt and plvrb does in pl/sql?

1145

Is clustered index a primary key?

952

What is trigger explain it?

1020

What is rank function in sql?

1033

Is primary key clustered index?

954

what are myisam tables? : Sql dba

1038

What is difference between primary and secondary key?

1034

How does index help in query performance?

1033

What is the purpose of normalization?

1049

how to use 'mysql' to run sql statements? : Sql dba

1060

What does cursor do in sql?

1031

How do you use collections in procedure to return the resultset?

2245