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
- 17018 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / avaneesh bajoria
select top 1 t2.region , count(t1.tsize) as co from tsize
t1,region t2
where t1.empid = t2.empid
group by t2.region,t1.tsize
having t1.tsize = 3 order by co desc
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is the partitioning method?
What are sql dirty pages?
Do you know how to store and query spatial data?
Do you know how to make remote connection in database?
What is table value parameters (tvp)?
Where actually sql azure database is hosted?
Explain the concept of view and Types of views in SQL server?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Define a cross join?
Explain tables in SQL Azure?
Why should you use or avoid select * statements?
What is 2nf example?
what are the types of indexes? : Sql server database administration
Explain “row_number()” in sql server with an example?
how you can list all the tables in a database?
