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

What do you understand by a database object?

1105

What is oracle database 10g express edition?

1168

How to use "for" statements in oracle?

1120

How to connect to the server with user account: sys?

1059

How to convert characters to numbers in oracle?

1112

What are the restrictions in a oracle read only transaction?

1079

How to define a cusotmer as a supplier in ORACLE R12

2302

Explain table?

1174

Explain the use of tables option in exp command.

1166

What is a tns service name?

1056

What are the various oracle database objects?

1201

How to connect asp pages to oracle servers?

1119

What is the difference between truncate & delete command?

1233

How to create id with auto_increment on oracle?

1040

Explain the features of oracle?

1107