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
- 8391 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 many types of tables are there in oracle?
What is sharded cluster?
Explain an index segment?
Explain the features of oracle?
Explain the use of rows option in exp command.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How oracle handles dead locks?
WHAT IS ecc 6.0
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is a sub query and what are the different types of subqueries?
How do we get field detail of a table?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is the usage of control file in oracle?
query optmization techniques and quwry analyser+projects+ppts
How to get a create statement for an existing table?
