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

Explain implicit cursor.

977

What language does oracle use?

1065

What are the general rules on data consistency?

976

Whether any commands are used for months calculation? If so, what are they?

1057

How to resolve the ORA-39133 error in Oracle?

1069

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2203

List out the difference between commit, rollback, and savepoint?

1005

defination of bitmap index

2073

what is Single Byte Overhead...?

2516

Explain oracle left join with an example?

967

How to define a variable to match a table column data type?

952

What is difference between cartesian join and cross join?

1044

How do I manually uninstall oracle client?

1045

What is data type in oracle?

1072

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2008