select b.region from table1 as a,table2 as b where a.employeeid=b.employee

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

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

Answer Posted / manisha

select b.region from table1 as a,table2 as b
where a.employeeid=b.employeeid and a.[tshirt size]=3

Is This Answer Correct ?

0 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a bit datatype?

991

What is the difference between left and right outer join?

1071

Explain the difference between HTTP and HTTPS in database?

1040

what stored procedure would you use to view lock information? : Sql server administration

978

Explain what is dbcc?

1016

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2072

What is db stored procedure?

883

What is the use of keyword with encryption.

1032

What is the chart in report?

161

What are the advantages of user defined function?

988

What is the use of partition by in sql server?

935

Does partitioning help performance?

940

Is sql server 2016 free?

948

Explain differentiate between a having clause and a where clause?

916

What is an expensive query?

934