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

Is port 1433 secure?

1041

What is 2nf in normalization?

1058

What is efficiency data?

1004

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1176

What is query parameter in ssrs?

167

Can another user execute your local temporary stored procedures?

1027

How to insert multiple rows with a subquery?

1193

What is blocking?

1136

What are tables in sql server?

1098

What is stored in the mssqlsystemresource database? : sql server database administration

1081

What is a hint?

1060

Write a sql query to delete duplicate records from a table called table1

1088

What is snapshot report?

172

What is normalization of database? What are its benefits?

1073

How to create indexed view?

1109