select min(marks) from (SELECT sid FROM(SELECT sid FROM STUDENT ORDER BY SI

find out the second highest salary?

Question Posted / yobu

Answer Posted / yobu

select min(marks) from (SELECT sid FROM(SELECT sid FROM STUDENT ORDER BY SId desc) WHERE ROWNUM <=2);

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why is oracle so popular?

998

How do we create privileges in oracle?

1047

What are the restrictions on external table columns?

1054

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

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

1087

What are the system predefined user roles?

1043

Explain what are synonyms used for?

1035

What is a oracle database?

1056

Explain what are the uses of rollback segment?

1016

List the types of joins used in writing subqueries?

998

How to empty your oracle recycle bin?

1022

What are the varoius components of physical database structure of oracle database?

1006

What is an external table?

1021

What happens if the imported table already exists?

1033

How to invoke the data pump export utility?

1187