SELECT SAL FROM EMP E WHERE &N-1 =(SELECT COUNT(*) FROM EMP WHERE E.S

find out the third highest salary?

Question Posted / esha gautam

92 Answers
147697 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answer Posted / esha gautam

SELECT SAL FROM EMP E WHERE &N-1 =(SELECT COUNT(*) FROM EMP
WHERE E.SAL<SAL);

HERE N FOR NTH SALARY!!!!!!!!!!!!!!!!!!!!

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is redo log?

1006

What is a database table in oracle?

954

Give the constructs of a package, function or a procedure.

984

What is oracle data type?

903

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

978

Explain what are clusters?

1042

How to write numeric literals in oracle?

1128

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1894

What is the difference between substr and instr?

980

How to use select statement to count the number of rows in oracle?

991

How to download oracle database 10g xe?

960

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1047

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2997

How to write a query with an inner join in oracle?

976

What is columnar storage what is the advantage?

986