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
what is the dual table in oracle?
what is the difference between data migration and production migration.
What are the different pseudo commands? Explain in general?
What is the relation of a user account and a schema in oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How to define a cusotmer as a supplier in ORACLE R12
How to create a new view in oracle?
How to omit columns with default values in insert statement in oracle?
How to drop an existing view in oracle?
What is the relation of a user account and a schema?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is a data lock in oracle?
How to rename a column in an existing table?
How to set up autotrace for a user account?
How to define an anonymous procedure with variables?