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
- 30201 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 sql functions? Describe the different types of sql functions?
Is pl sql better than sql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Can we insert data in view?
What is pivot in sql?
How can I delete duplicate rows?
What programs use sql?
What is a null value?
Why procedure is used in sql?
What is a nested table in word?
What is the use of desc in sql?
What are %type and %rowtype for?
What is scalar function in sql?
What is a sql schema used for?
Can you join a table to itself?
