Interested to Buy Any Domain ? << Click Here >> for more details...
two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)
- 2 Answers
- 4842 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ajit
select e.ename,d.deptno,max(e.sal)
from emp e, dept d
where e.deptno = d.deptno
group by e.ename, d.deptno;
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / no_name
select deptno,dname,max(sal) dept_max
from
(select empno, e.deptno, d.dname, e.sal
from emp e,
dept d
where e.deptno = d.deptno)
group by deptno,dname;
| Is This Answer Correct ? | 2 Yes | 2 No |
What are the types of partitions in oracle?
Explain what does a control file contain?
What are the oracle differences between nvl and coalesce
List out the components of logical database structure of oracle database.
What is a Temporary Segment ?
What is the difference between 10g OEM and 11g OEM?
How to resolve name conflicts between variables and columns?
how to insert the image in table
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
Give the various exception types.
what is primary key?
Difference between open_form and call_form in oracle.
Oracle General 
