Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
- 5 Answers
- 10483 Views
- College School Exams Tests, DELL, I also Faced
- E-Mail Answers
Answer Posted / guest
select *from emp where max(sal)=dept;
| Is This Answer Correct ? | 2 Yes | 16 No |
Post New Answer View All Answers
various types of hints and their usage
How to declare a local variable?
How to open and close an explicit cursor in oracle?
what happened to the global index when I truncate the data in one of the partition?
Explain self joins in oracle?
Can a formula column be obtained through a select statement ?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What happens if the update subquery returns multiple rows?
How to shutdown your 10g xe server?
State any two functions of oracle?
What is MTTR advisor in Oracle?
How to create tables for odbc connection testing?
What is a Garbage Collection? and what is full recursive Garbage collection?
How to create an oracle database manually?
Explain what does a control file contain?
