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
16448 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 the difference in accessing db between sql server vs sql azure?

174

What is the exact numeric data type in sql?

963

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

929

How to create an index on a view?

991

In which tcp/ip port does sql server run? Can it be changed?

948

Define tempdb database?

945

How to find the login name linked to a given user name?

948

How many categories of functions based their return modes?

1063

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

1024

How do you send email on SQL Server?

1005

How you can change the database name in SQL SERVER?

1138

what is the sql equivaent of the dataset relation object ?

1966

How to get a list of columns in a view using "sys.columns" in ms sql server?

929

Explain cdc and sql injection?

916

Explain features of analysis services?

928