SQL> select salary from(select salary,rownum a from(select salary from e

find out the second highest salary?

Question Posted / prem

Answer Posted / prem

SQL> select salary from(select salary,rownum a from(select salary from employee order by salary desc))where a=2;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What happens if the imported table already exists?

1033

State all possible different index configurations a table can possibly have?

996

When do I need to use a semicolon vs a slash in oracle sql?

1090

Can you tell me how to add new column in existing views?how?How is possible?

1444

What is a directory object?

1097

How to start instance with a minimal initialization parameter file?

1040

Whats the benefit of dbms_stats over analyze?

1999

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2969

How do you bind variables in oracle?

980

How to use attributes of the implicit cursor in oracle?

1008

What is meant by joins?

1058

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

How to list all indexes in your schema?

1093

What is a user role in oracle?

1129

What is a nvl function?

1028