Query to get max and second max in oracle in one query ?
Answer Posted / mehul
select max(sal) from emp where sal not in ( select max(sal)
from emp)
| Is This Answer Correct ? | 29 Yes | 12 No |
Post New Answer View All Answers
Give syntax for SQL and ORACLE joins.
How does Oracle guarantee data integrity of data changes?
defination of bitmap index
Explain oracle left join with an example?
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.
How to rebuild an index in oracle?
How to build data dictionary view an new database?
How many types of synonyms in Oracle?
WHAT IS ecc 6.0
How to drop a stored function?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to return top 5 rows in oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is ordinary table in oracle?
How to pass a parameter to a cursor in oracle?