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
- 4845 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 an oracle cursor variable?
What is key preserved table?
What is a tns file?
What privilege is needed for a user to query tables in another schema?
Explain the use of ignore option in imp command.
What are the differences between date and timestamp in oracle?
What is where clause in oracle?
How many types of tables supported by oracle?
does the query needs a hint to access a materialized view?
What are ddl statements in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Why oracle is used?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What is a private synonym?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
