Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 65520 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 is execute immediate in oracle?
Explain oracle data types with examples?
How to use an explicit cursor without open statements?
What is a trigger and what are its types in oracle?
what are steps for interface? where is exchange rate defined in which table?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Explain oracle instance.
What is an oracle tablespace?
What happens in oracle commit?
What is pragma autonomous transaction in oracle?
What is Virtual Private Database in Oracle?
What is a private synonym?
What is raw datatype in oracle?
What is an oracle transaction?
6. Display the client name and order date for all orders using the traditional method.
