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
- 24264 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / sonal
select * from (select ename, deptno,sal
from emp where deptno in(10 , 20)
order by sal desc)
where rownum < =1
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
what is meant by nl2br()? : Sql dba
Mention what is the plv (pl/vision) package offers?
How do I find duplicates in a single column in sql?
Write the command to remove all players named sachin from the players table.
What trigger means?
Sql technical questions
what is bcp? When does it used? : Sql dba
What is a relationship and what are they?
Can cursors be part of a trigger body?
What is restrict in sql?
What is data abstraction in sql?
Do ddl statements need commit?
Why do we use sql constraints?
How do I start sql from command line?
What is keys and its types?
