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
- 4920 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a oracle database?
How to create a new user account in oracle?
Why does for update in oracle 8 cause an ora-01002 error?
What is the use of oracle?
When do I need to use a semicolon vs a slash in oracle sql?
Explain an exception?
What is columnar storage what is the advantage?
How to insert multiple rows with one insert statement in oracle?
How to convert character types to numeric types?
What are the various types of snapshots ?
How to create a new table in oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What are named parameters?
Does oracle database need java?
