select rownum as rowid,salary from (salary from employees oderby salary

how to calcuate the second highest salary of he employee

Question Posted / sunilpanghal

Answer Posted / sunilpanghal

select rownum as rowid,salary from (salary from employees
oderby salary )where rownum <2

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

how to select first 5 records from a table? : Sql dba

922

what is uncommittable transactions? : Transact sql

956

what is isam? : Sql dba

953

What is application trigger?

947

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3518

What are the properties of a transaction?

1072

What is a .db file?

928

How does sql*loader handles newline characters in a record? : aql loader

987

how can we destroy the cookie? : Sql dba

961

What does joining a thread mean?

975

What is Difference Between Unique and Primary Key Constraints?

1060

How run sql*plus commands that are stored in a local file?

976

How to avoid using cursors?

1041

What does sign mean sql?

1022

Explain spool.

1113