SELECT * (SELECT SAL, ROWNUM RN FROM EMP ORDER BY SAL DESC) WHERE RN=

how to findout the 100th maximum salary

Question Posted / akki reddy

Answer Posted / akki reddy

SELECT *
(SELECT SAL, ROWNUM RN FROM EMP ORDER BY SAL DESC)
WHERE RN=100;

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what is meant by urlencode and urldocode? : Sql dba

1231

Explain the rollback statement?

1072

how to fetch common records from two tables? : Sql dba

1248

explain commit and rollback in mysql : sql dba

1068

what are the 'mysql' command line options? : Sql dba

1128

Explain the difference in execution of triggers and stored procedures?

1060

What is pivot in sql?

969

What is secondary key?

983

How to revise and re-run the last sql command?

1213

What is the advantage of index in sql?

1014

what is the difference between char_length and length? : Sql dba

1103

What is dialect in sql?

987

How to select unique records from a table?

1105

What is forward declaration in pl sql?

1139

what is heap table? : Sql dba

1136