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
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 |
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 |
How can you merge two tables in oracle?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Differentiate between function and procedure in oracle.
what are the things that you consider while creating indexes on partitioning tables?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
Why does oracle 9i treat an empty string as null?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
Can we create index on views?
19 Answers CTS, Syntel, TCS,
where do i find oracle interview questions.
Why we choose emp number as primarykey?
What is the sid in oracle?