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

Is mariadb nosql?

1041

What is prepared statement in sql?

1047

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1065

what is the difference between clustered and non clustered index in sql? : Sql dba

1123

What will you get by the cursor attribute sql%found?

961

Is clustered index a primary key?

947

What is orm in sql?

1046

What is pl sql script?

1027

write an sql query to find names of employee start with 'a'? : Sql dba

1027

List the various privileges that a user can grant to another user?

1038

What are the types of variables use in pl sql?

1042

How many developers work on postgresql?

976

What is sequence in sql?

999

What is the syntax and use of the coalesce function?

1171

tell me about various levels of constraint. : Sql dba

1035