find out the second highest salary?
Answer Posted / subash
select sal from emp e
where 2=(select count(distinct sal) from emp b where
b.sal>e.sal)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain the use of control file?
What are the logical operations?
Explain what are synonyms used for?
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.
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?
types of indexes and the rationale behind choosing a particular index for a situation.
What is a cursor and what are the steps need to be taken?
How to generate query output in html format?
Where do we use decode and case statements?
Describe an oracle table?
When system tablespace is created?
How to delete a column in an existing table?
What is query image?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
How to end the current transaction in oracle?