Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17387 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
How do triggers work?
Do you know what is sql service broker?
What are the different types of join?
What are the different ways you can create databases in sql server?
What are the different index configurations a table can have?
What does ss stand for sexually?
Can you roll back the ddl statement in a trigger?
Explain about protocol layer present in SQL server?
What is difference between views and stored procedures?
What is the difference between getdate and sysdatetime?
Can we insert data if clustered index is disabled?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
How to create and drop temp table in sql server?
What is the difference between drop table and truncate table?
What does it mean to normalize a database and why would you do it?
