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
- 4918 Views
- I also Faced
- E-Mail Answers
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 parameter mode that can be passed to a procedure?
What is a dead lock in oracle?
List the types of joins used in writing subqueries?
Is oracle the best database?
How will you identify oracle database software release?
How to write date and time literals in oracle?
What is the difference between translate and replace in oracle?
Explain how you would restore a database using RMAN to Point in Time?
What are a query and state the different types of queries and their uses?
What is SQL access advisor in Oracle?
Why cursor variables are easier to use than cursors?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Why packages are used in oracle?
How to use values from other tables in update statements using oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
