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
- 14872 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / susanna
select top 1 Count(r.Empid) as Ct,r.regionId from Emp_Region
r inner join Emp_Tshirt t on r.Empid= t.EmpId
where t.T_size=3 group by r.regionId order by Ct desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you understand by replication in sql server? Mention the different types of replication in sql server.
If the job running very slow what is the action you do
What objects does the fn_my_permissions function reports on? : sql server security
Explain what is raid and what are different types of raid levels?
Detail about query optimizer?
What does it mean to normalize a database and why would you do it?
How to modify the underlying query of an existing view?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
How to attach adventureworkslt physical files to the server?
What is nolock?
What is the difference between a function and a trigger?
Explain how you can deploy an SSRS report?
What the different components of Replication and what is their use?
What are the Advantages of using CTE in sql server?
What is the difference between resultset and resultsetmetadata?
