HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT
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
How oracle handles dead locks?
What is a private synonym?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Explain oracle insert into command?
How to use "for" statements in oracle?
What is query image?
What are the tools for Oracle ?
How to do clean up if create database failed?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to use in conditions in oracle?
Can objects of the same schema reside in different tablespace?
How many types of database triggers exist?
Where is the export dump file located?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What are the differences between lov and list item?