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
- 16591 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 are the advantages of using a stored procedure?
What is row_number()?
What are the export options of ssrs?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is difference between delete & truncate commands?
What is a partition function in sql server?
What are the key configuration files for sql server reporting services ?
How to modify an existing stored procedure in ms sql server?
what is the sql equivaent of the dataset relation object ?
New concepts of sql server 2005 use in your project.
Explain what are the restrictions while creating batches in sql server?
Explain system scalar functions?
What is the stuff?
What is difference between index and primary key?
Explain what is analysis service repository?
