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
- 29839 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 are the differences between char and varchar? : Sql dba
Why is the cursor important?
what are the t string functions available in tsql? : Transact sql
what is the difference difference between procedure and packages
what is meant by urlencode and urldocode? : Sql dba
What does partition by mean in sql?
What is data type in database?
what is cursor. write example of it. What are the attributes of cursor.
What are the advantages of normalization?
Write the alter statement to enable all the triggers on the t.students table.
Which data dictionary views have the information on the triggers that are available in the database?
What is a trigger in sql?
What is the use of sql trace?
What is minus?
Can we commit in trigger?
