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
- 30551 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / srilekha
select ename from table where sal=(select max(sal) from
table) and depetno in (10,20)
| Is This Answer Correct ? | 27 Yes | 20 No |
Post New Answer View All Answers
What are pl/sql packages?
How do I find duplicates in the same column?
How long does it take to learn pl sql?
What is foreign key in sql with example?
Is primary key clustered or nonclustered?
Does execute immediate commit?
what are the properties and different types of sub-queries? : Sql dba
What is 19 null in sql?
What are the types of join and explain each?
What is the difference between instead of trigger and after trigger?
How do I partition a table in sql?
What is pl sql architecture?
what is single byte over head in oracle..?
What is the difference between alter trigger and drop trigger statements?
What is duration in sql profiler trace?
