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
- 8231 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
select top(1) sal From sample
where sal
in (select top(2) salfrom sample order by saldesc)
order by sal asc
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
How do we get field detail of a table?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is an external table?
Give syntax for SQL and ORACLE joins.
How to speed up webrick?
please explain.. DB architecture ...
Explain the use of record option in exp command.
What are named parameters?
What is a data lock in oracle?
if you ctreate table identity
How to drop an existing view in oracle?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to define an oracle sub procedure?
