SELECT B.Region FROM TABLE1 AS A INNER JOIN TABLE2 AS B ON A.EmployeeID=B.

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

Question Posted / sandeep narayanan

15 Answers
17420 Views
Google, I also Faced
E-Mail Answers

Answer Posted / sandeep narayanan

SELECT B.Region FROM TABLE1 AS A
INNER JOIN TABLE2 AS B ON A.EmployeeID=B.EmployeeID
WHERE A.TShirtSize=3

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does the on delete cascade option do?

1068

How to display a past time in days, hours and minutes?

1061

what are the different stages of Report Processing?

141

What is the purpose of update statistics and scope_identity() function?

1160

What is SQL Azure Fabric?

112

What are the advantages of using stored procedures?

1006

Explain sub-query?

1014

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

940

How to add code to the existing article (using improve article)?

1167

Explain partitioned view?

1133

How to list all schemas in a database?

1103

What is an example of a primary key?

1039

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

2014

How do you make a trace?

1076

Scalability, Availability, Integration with internet, etc.)?

2938