Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 8638 Views
- I also Faced
- E-Mail Answers
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
how can we store any pdf file in oracle
what are the advantages of running a database in archive log mode?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to connect to a local oracle 10g xe server?
What is the maximum number of triggers that can be applied to a single table?
Why use resource manager in Oracle?
How to enter a new row into a table interactively?
Explain a private synonyms?
What is bulk copy or bcp in oracle?
How many types of database triggers exist?
What are the general rules on data consistency?
material view and view disadvantages?
