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
16603 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

How to list all schemas in a database?

1023

Do you know what is replace and stuff function in sql server?

973

Define outer join in sql server joins?

908

What does indexation mean?

935

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1102

Explain what is row_number function?

988

What is the parse query button used for?

1001

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

930

Give main differences between "Truncate" and "Delete".

1059

How to check parameter value in stored procedure sql server?

941

What is an indice?

1002

Why we use functions in sql server?

1028

How to execute the cursor queries with "open" statements?

1123

What are the hotfixes and patches in sql server?

996

what is normalization? : Sql server database administration

1043