SELECT B.* FROM (SELECT A.*,DENSE_RANK() OVER(ORDER BY SAL DESC)

how to findout the 100th maximum salary

Question Posted / siva prasad

Answer Posted / siva prasad

SELECT B.* FROM
(SELECT A.*,DENSE_RANK() OVER(ORDER BY SAL DESC) V_SAL
FROM EMP A )B
WHERE V_SAL = 100

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which join is like inner join?

978

Explain the uses of control file.

994

What are the parts of a sql statement?

1030

what are different types of collation sensitivity? : Sql dba

1025

What are the query optimization techniques?

888

can sql servers linked to other servers like oracle? : Sql dba

956

Explain 3 basic parts of a trigger.

1257

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

986

What is the best free sql database?

1001

What does an inner join do?

1093

What is sql injection owasp?

1001

What is the difference between partitioning and sharding?

950

What are sql constraints?

1127

How to run sql*plus commands in sql developer?

1086

Explain what is rdbms?

993