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
- 15 Answers
- 14122 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
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Explain the truncate command? : SQL Server Architecture
What are the types of lock supported by ?
What are a scheduled jobs?
How to create sub reports?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
Can a table be moved to different filegroup?
What is transaction server distributed transaction?
What is shared lock?
How to change the password of a login name in ms sql server?
Where are sql server user names and passwords stored in sql server?
What are the recovery models in sql server 2000?
What are a database and a data warehouse?
Define primary key?
How to enable/disable indexes?
