Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
Answer Posted / raj
select max(sal) from emp where sal < (select max(sal) from
emp)
Is This Answer Correct ? | 31 Yes | 1 No |
Post New Answer View All Answers
How do you bind variables in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is data type in oracle?
What is an oracle?
what is the difference between restoring and recovering?
How to list all indexes in your schema?
What is columnar storage what is the advantage?
What is a database table in oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Can we commit inside a function in oracle?
What are the attributes of the cursor?
how to make an oracle object
master table and child table performances and comparisons in Oracle ?
What is ordinary table in oracle?
What are the differences between char and nchar in oracle?