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
- 29550 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
Does mysql_real_escape_string prevent sql injection?
How would you convert date into julian date format?
Is sql a microsoft product?
I need a function for a train ticket reservation please answer it thanks in advance
tell us something about heap tables. : Sql dba
What is compiled query?
Explain the significance of the & and && operators in pl sql.
What are system versioned tables?
How many parts of a pl sql block are optional?
What does over partition by mean in sql?
What are string functions in sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
define join and explain different type of joins? : Sql dba
what is meant by nl2br()? : Sql dba
Show the cursor attributes of pl/sql.
