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
- 4987 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 |
After update how do u know how many records got updated
Difference between open_form and call_form in oracle.
What are the uses of linked server and explain it in detail?
what is trigger?
How to write a query with a left outer join in oracle?
How to create an oracle database manually?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain the difference between a procedure and a function?
How to delete a column in an existing table in oracle?
How to use "out" parameter properly?
Oracle General 
