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

How do I send sql query results to excel?

1072

Is sql difficult?

1163

What is procedure in pl sql?

1050

Is sql a programming?

980

Is oracel sql developer written in java?

1122

Is mariadb a nosql database?

1057

what are different types of collation sensitivity? : Sql dba

1075

What is break?

1203

How to get unique records from a table?

978

What are the usages of sql?

1059

What is the difference between between and in condition operators?

1010

Can a procedure in a package be overloaded?

1047

how can we know the count/number of elements of an array? : Sql dba

1066

How many types of sql are there?

991

What kind of join is join?

977