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
- 30463 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 do I clear the screen in sql plus?
What is the use of count (*) in sql?
What does <> sql mean?
what is rdbms? : Sql dba
How do you declare a user-defined exception?
Can we join 3 tables in sql?
Why are aggregate functions called so?
What is sharding in sql?
What are the types of optimization?
Which type of cursor is used to execute the dml statement?
How to process query result in pl/sql?
Explain the order of sql statement execution?
What steps server process has to take to execute an update statement?
How do I find duplicates in two columns?
How do you optimize a stored procedure query?
