Query to get max and second max in oracle in one query ?
Answer Posted / purna chowdary
Select Sal From Emp A
WHERE 1=(Select Count(Sal) From Emp B
WHERE B.Sal>A.sal)
GROUP By Sal Desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is Reduced List of Values?
Explain user account with reference to oracle.
Can you create a synonym without having a table?
What privilege is needed for a user to create tables in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
When do you get a .pll extension in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Is the After report trigger fired if the report execution fails ?
Explain what are the different type of segments?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What are the set operators union, union all, minus & intersect meant to do?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How are extents allocated to a segment?