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

What is execute immediate?

1163

What are the different ddl commands in sql?

1251

What are the types of sql commands?

1160

How many commands are in sql?

1119

Enlist some predefined exceptions?

1113

How do I remove sql plus from windows 10?

1145

How do I remove all records from a table?

1116

What is faster join or subquery?

1065

what is view? : Sql dba

1029

Why triggers are used?

1038

What is implicit cursor in pl sql?

1148

what is the stuff function and how does it differ from the replace function? : Sql dba

1107

how to return query output in html format? : Sql dba

1121

What is pragma in sql?

1127

What is a temporal data type?

1114