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
- 4886 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 |
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
find out first highest salary?
10 Answers Verinon Technology Solutions,
how to retrive xml data for using sql query?
How to use "out" parameter properly?
Whether any commands are used for months calculation? If so, what are they?
What is clustered table in Oracle?
What are the execution control statements in oracle?
Which database is better for os platform dependency?
How do I uninstall oracle client from windows?
What are the differences between blob and clob in oracle?
How do we get field details of a table?
How to list all indexes in your schema?
Oracle General 
