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
- 10889 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
Difference between hot backup vs. Cold backup?
How does oracle handle read consistency?
How to execute the package in oracle?
how may join possible between (requisition with purchase order)
How to check your oracle database 10g xe installation?
How do I limit the number of oracle database connections generated by weblogic server?
How to rename an existing table?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What are the various oracle database objects?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
what is the difference between functional dependecy and multilevel dependency?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How do I manually uninstall oracle client?
What are the arithmetic operations?
How to create an oracle database manually?
