two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)
- 2 Answers
- 4067 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to display row numbers with the records?
Explain integrity constraint?
How to create id with auto_increment on oracle?
How to convert a string to a date in oracle database?
definition of cluster and non-clustered index?
Explain a data segment?
What is oracle instant client?
How to write a left outer join with the where clause in oracle?
How to drop an existing table in oracle?
How to check the oracle tns settings?
How to execute a stored program unit?
How to write a query with an inner join in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to select some rows from a table in oracle?
