Interested to Buy Any Domain ? << Click Here >> for more details...
consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.
- 24 Answers
- 31230 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / kishore
select * from em where sal in (select max(sal) from em
where dno in (10,20) group by dno) and dno in (10,20)
where em = table name
dno = department number
sal = salary
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Why commit is not used in triggers?
what is a stored procedure? : Sql dba
What are the parameter modes supported by pl/sql?
What is varchar sql?
What is the limitation on the block size of pl/sql?
What is the main difference between sql and pl/sql?
Which sorts rows in sql?
Is join same as left join?
Difference between table function and pipelined function?
What is pl sql code?
Can a select statement fire a trigger?
Can two tables have same primary key?
How does one use sql*loader to load images, sound clips and documents? : aql loader
Can we insert data in view?
Does sql use python?
