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
How many types of segments in Oracle?
What happens if you use a wrong connect identifier?
What is meant by raw datatype?
Why packages are used in oracle?
What is the use of file param in imp command?
What is the usage of synonyms?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to connect to the server with user account: sys?
What is a snapshot log?
What are the advantages of oracle 12c?
How does the on-delete-cascade statement work?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
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?
Which environment variables are absolutely critical in order to run the OUI?
What are the different types of partitions in oracle?