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
- 31210 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
What is the maximum rows in csv?
What is oracle and pl sql?
What is the requirement of self-join?
what is primary key? : Sql dba
What are the types of functions in sql?
What are stuff and replace function?
How many disk partitions should I have?
What is schema in sql example?
What is the difference between row level and statement level trigger?
What is thread join () in threading?
What is sql analyzer?
what is the difference between truncate and delete statement? : Transact sql
What does over partition by mean in sql?
What are the sql aggregate functions?
How to return an array from java to pl/sql?
