two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)
Answer Posted / 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 |
Post New Answer View All Answers
how do u setup a replication site?
What are the uses of linked server and explain it in detail?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is the sid in oracle?
What are the execution control statements?
How will you write a query to get a 5th rank student from a table student_report?
what is dynamic SGA and static SGA
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is the usage of synonyms?
How to define a data source name (dsn) in odbc manager?
How to drop an existing table in oracle?
Explain an exception and its types?
How to create a new user account in oracle?
How to see the table columns used in an index?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?