Interested to Buy Any Domain ? << Click Here >> for more details...
can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
- 15 Answers
- 17400 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / ramesh babu
Create table #temptshirt(empid int,tshirt int)
Create table #tempregion(empid int,region varchar(200))
Insert into #temptshirt(empid,tshirt)values(100,2),(102,4),
(103,5),(104,3),(105,3),(106,3),(107,5),(108,6),(109,3),
(110,4),(111,3)
Insert into #tempregion(empid,region)values(100,'SA'),
(102,'SA'),(103,'UK'),(104,'UK'),(105,'PHL'),(106,'US'),
(107,'US'),(108,'US'),(109,'RSA'),(110,'RSA'),(111,'UK')
Select Top 1 T.region,T.Total
from
(
Select b.region,COUNT(*)[Total] from #temptshirt a inner
join #tempregion b on a.empid=b.empid
Where a.tshirt=3
group by b.region
)T
order by 2 desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is enhanced database mirroring in sql server 2008?
How to invoke a trigger on demand?
What is cross join in sql server joins?
How to create a Master database in SQL server ?
What is index, cluster index and nonclustered index?
Why we use the openxml clause?
How many columns can exist together per table?
How to add code to the existing article (using improve article)?
Delete duplicate rows without using rowid.
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
List out the differences between the clustered index and non-clustered index in sql server?
How do I create a trace in sql server?
What are alternate keys?
Do you know what are acid properties of transaction?
What is the tcp/ip port on which sql server runs?
