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
- 29857 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / anil pednekar
select table1.ename from (select deptno, max(sal) as sal1
from table1 group by deptno having deptno in(1,2)) as T1,
table1 where T1.deptno=table1.deptno and
T1.sal1=table1.sal
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a subquery in sql?
Can we use update in sql function?
What is normalization in a database?
What is mutating sql table?
what is sql in mysql? : Sql dba
what is meant by nl2br()? : Sql dba
What is pl sql package?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What operating systems are supported by oracle sql developer?
What are all the common sql functions?
What are sql built in functions?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What are the types of index in sql?
What is data control language (dcl)?
What is the difference between distinct and unique in sql?
