select region from tab2 where empid in(select empid from tab1 where tshir

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 / ram

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

Answer Posted / ram

select region from tab2 where empid in(select empid from
tab1 where tshirtsize=3)

Is This Answer Correct ?

1 Yes

10 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

please differentiate between delete and truncate?

993

How to generate create procedure script on an existing stored procedure?

1010

How do you trace the traffic hitting a sql server?

1141

Explain contrast amongst grouped and non-bunched records?

1020

Define model database?

979

Can you explain what are commit and rollback in sql?

940

How many null values we can have in a unique key field in sql server?

958

How do I know if localdb is running?

953

How to find the list of fixed hard drive and free space on server?

1199

Can sql server 2016 run on windows 7?

916

What is difference between global temporary tables and local temporary tables?

1238

What is catalog views?

1068

Explain four layers of abstraction microsoft architectured?

147

What are partitioned views and distributed partitioned views?

1022

Describe and explain about SQL native client?

1108