Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 64558 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / haddy
select ename,salary from (select distinct(salary) from
employee order by salary desc) where rownum<=2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the uses of a database trigger?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Explain an index segment?
How to define a sub function?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Is oracle a programming language?
How to export several tables together?
What is oracle join syntax?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How do I learn what codesets are available in oracle?
What is a database schema in oracle?
Describe varray?
What are the differences between char and varchar2 in oracle?
What is coalesce function?
Can we insert data in view oracle?
