two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)

Answers were Sorted based on User's Feedback



two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,e..

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

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,e..

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

Post New Answer

More Oracle General Interview Questions

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,


What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

1 Answers  


Can we convert a date to char in oracle and if so, what would be the syntax?

0 Answers  


How to use "while" statements in oracle?

0 Answers  


How to change system global area (sga) in oracle?

0 Answers  






what happened to the global index when I truncate the data in one of the partition?

0 Answers  


What happens in oracle commit?

0 Answers  


How to create a new table in your schema?

0 Answers  


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

0 Answers   IBM,


What are various constraints used in SQL?

1 Answers   Polaris,


How can we find the size of a database?

2 Answers  


What exactly do quotation marks around the table name do?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)