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
- 14117 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
What does Master database contains?
Name few endpoints exposed by ssrs 2012?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What is the difference between indexing and hashing?
What are different types of join?
Explain the microsoft sql server delete command?
What is subquery? Explain the properties of a subquery?
What do you mean by cardinality?
What are sub reports?
What are the differences between stored procedure and view in sql server?
What is CTE in SQL
What are click through reports?
Explain what is lock escalation?
How do I create a stored procedure in dbml?
Explain about integration services of Microsoft SQL server?
