find out the third highest salary?
Answer Posted / asadullahrao
select max(sal) from emp where sal<(select max(sal) from
emp where sal<(select max(sal) from emp))
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Why we use bulk collect in oracle?
How to assign a table row to a record variable?
How to view the data files in the current database?
What do you mean by a deadlock?
What is a data dictionary and how can it be created?
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 to compare dates in oracle sql?
List out the components of logical database structure of oracle database.
What is program global area (pga) in oracle?
What is max rowid in oracle?
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 work with data objects interactively?
What are the advantages of oracle?
How to display row numbers with the records?
How would you go about verifying the network name that the local_listener is currently using?