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
- 24311 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / sumesh s.g
select Name from TBL_Employee
where Salary in(
select max(Salary) from dbo.TBL_Employee
group by DepID
having DepID in(10,20))
--Happy Codding--
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
how to install mysql? : Sql dba
What does pl sql stand for?
what are all different types of collation sensitivity? : Sql dba
What is compute?
what is 'mysqlcheck'? : Sql dba
what are local and global variables and their differences? : Sql dba
Is there any restriction on the use of union in embedded sql?
Can we alter stored procedure?
What is triggering circuit?
What is a natural join?
What can I use instead of union in sql?
how to use myisamchk to check or repair myisam tables? : Sql dba
Can we edit a view in sql?
What is the syntax to add a record to a table?
What is synchronized subquery?
