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
- 8229 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
select top(2) sal from emp where sal order by desc
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Compare and contrast between sql and sql server and explain its various functions?
Is oracle a language?
Can we insert data in view oracle?
How to write date and time interval literals in oracle?
What is program global area (pga) in oracle?
How to use an explicit cursor without open statements?
What is a snapshot log?
Explain how are indexes update?
Difference between inner join vs where ?
What privilege is needed for a user to create tables in oracle?
Does oracle charge for java?
How to download oracle database 10g xe?
Explain the dml?
What are the components of logical database structure in oracle database?
