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
Why is oracle database so popular?
Explain cascading triggers.
How to connect to a remote server?
What is oracle host variable?
How do I connect to oracle?
State some uses of redo log files?
What are advantages of dateset in datastage?
What is oracle database 10g express edition?
What is Data Dictionary Cache in Oracle?
What is the maximum limit on the number of columns in a table?
How to rename an index in oracle?
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.
How to convert dates to characters in oracle?
What do you mean by a tablespace?
What is the difference between count (*), count (expression), count (distinct expression)?