select region from table2 t2 JOIN table1 t1 ON (t1.eid = t2.eid and t1.s

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 / himesh mistry

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

Answer Posted / himesh mistry

select region
from table2 t2 JOIN table1 t1 ON (t1.eid = t2.eid and
t1.size = 3)
group by region

Is This Answer Correct ?

3 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the triggers in sql?

1106

How to remove duplicate rows from table?

1253

How to create an index on an existing table in ms sql server?

981

What is ddl and dml commands?

907

What gets stored inside msdb database?

1252

What types of Joins are possible with Sql Server?

1122

Explain timestamp datatype?

976

What is the maximum length of an alert name?

1001

What is the default fill factor value?

1082

What are the properties of the transactions?

1119

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1021

How to find related tables in sql server?

948

what is a traditional network library for sql servers? : Sql server database administration

960

How to use values from other tables in update statements in ms sql server?

1118

What is the difference between the 2 operating modes of database mirroring?

1113