Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 64555 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / naveen
select sal from employee where sal >= (select max(sal) from
employee where sal not in (select max(sal) from employee))
| Is This Answer Correct ? | 7 Yes | 14 No |
Post New Answer View All Answers
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.
When do you get a .pll extension in oracle? Explain its importance
What is parameterized cursor in oracle?
Explain what does a control file contain?
How do you bind variables in oracle?
How to declare a local variable?
Is it possible to split the print reviewer into more than one region ?
What is a read only transaction in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is pragma autonomous transaction in oracle?
How to end the current transaction in oracle?
Explain table?
Write a syntax for update query in oracle?
Give the constructs of a package, function or a procedure.
What are the different oracle database objects?
