find out the second highest salary?
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 |
Post New Answer View All Answers
What is MTTR advisor in Oracle?
Explain cascading triggers.
Explain user account with reference to oracle.
What is the difference between PFILE and SPFILE in Oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to create a new user account in oracle?
What is snapshot is too old? Give and example for better understand.
How to call a stored function in oracle?
How to load data from external tables to regular tables?
How to assign a tablespace to a users in oracle?
How do I start tns listener?
Difference between the “verify” and “feedback” command?
How remove data files before opening a database?
What is a table index in oracle?
What is the use of file param in imp command?