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
- 17399 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / karthick veerappan
select top 1 region,count(*) from table2 where empid in
(select empid from table1 where tsize=3) group by region
order by count(*) desc
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
Can you leave a union at any time?
Explain left outer join and right outer join?
How to find the version of sql server? : sql server database administration
How do use Having,Group by,Group function in SQL?
What are the different types of stored procedures?
How to search for a string in all stored procedure in sql server?
What is amo? : sql server analysis services, ssas
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is sql server used for?
Name 3 ways to get an accurate count of the number of records in a table?
Does partitioning ssd reduce performance?
What is 5nf in normalization form?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What’s the use of custom fields in report?
How to remove duplicate rows from table?
