1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
Answer Posted / ramya
select max(sal) from employees where
sal < (select max(sal) from employees)
Is This Answer Correct ? | 21 Yes | 2 No |
Post New Answer View All Answers
Explain an exception and its types?
Please explain oracle left join with an example?
State the various uses of dbcc command?
What is the data type of dual table?
How to use windows user to connect to the server?
Why does Oracle not permit the use of PCTUSED with indexes?
How to create a stored function in oracle?
What is recovery manager(rman) backup in Oracle?
Explain an extent?
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.
What is a snapshot log?
What do you know about normalization? Explain in detail?
Explain self joins in oracle?
What is a cursor and what are the steps need to be taken?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?