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
16804 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 would you troubleshoot blocking? : Sql server database administration

969

What is a natural primary key?

1005

Why do we use non clustered index?

1063

How can you stop stored procedures from recompiling?

881

What are a database and a data warehouse?

1012

Where is trigger in sql server?

1028

What are Row versions of DataRow?

1009

how we use window authentication connection with sql server.?

1135

What is the recovery model?

973

What is TDS(Tabular Data Stream) Gateway?

121

Can we linked SharePoint to a SQL database?

1011

How to read data in a table with "select" statements?

954

Ways to improve the performance of a SQL Azure Database?

125

How to loop through result set objects using mssql_fetch_array()?

1054

Find nth lowest salary or get nth lowest salary?

1011