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
- 17396 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / ashok
select b.Region, a.TSize, Count(a.TSize)
as TSizecount from Table1 a,Table2 b where a.Empid =
b.Empid and a.TSize=3 group by region, TSize order by
Region, count(*), TSize desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is port 1433 secure?
What is an inner join?
What are sql server procedures?
What is a deadlock and what is a live lock?
Does sql server use t sql?
How to override dml statements with triggers?
What is the difference between for auto and for nested?
Explain acid?
What is a system database and what is a user database?
explain databases and sql server databases architecture? : Sql server database administration
How to rebuild indexes with alter index ... Rebuild?
Do you know what are the ways available in sql server to execute sql statements?
What are a scheduled jobs?
What is the difference between a function and a stored procedure?
Find first and last day of current month in sql server
