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
- 10632 Views
- College School Exams Tests, DELL, I also Faced
- E-Mail Answers
Answer Posted / harika
select dname,max(sal) from emp e,dept d
where d.deptno=e.deptno
group by d.deptno;
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
What is meant by an index?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to write a query with a left outer join in oracle?
What is the fastest query method to fetch data from the table?
Which is faster join or subquery in oracle?
What is the Tune Query
How to find the duplicate rows count from employees table in oracle?
How to Truncate Table in Oracle
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
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'));
What is oracle host variable?
What are the uses of linked server and explain it in detail?
How to drop an index?
What is BBED in Oracle?
What is meant by a deadlock situation?
