How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / mk
select Name from emp where sal=(select distinct(Max(sal))
from emp
| Is This Answer Correct ? | 4 Yes | 14 No |
Post New Answer View All Answers
What is system tablespace?
Explain self joins in oracle?
How many anonymous blocks can be defined?
Explain the use of grant option in exp command.
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.
Explain the use of analyse option in exp command.
Explain about functional dependency and its relation with table design?
How will you write a query to get a 5th rank student from a table student_report?
What is a nested table?
How to drop a stored function?
What are set operators?
What is redo log?
Why is oracle used?
What is a package ? What are the advantages of package ?
What is oracle rowcount?