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
- 14121 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / himesh mistry
select region
from table2 t2 JOIN table1 t1 ON (t1.eid = t2.eid and
t1.size = 3)
group by region
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Can truncate be rolled back?
What is an entity-relationship diagram (erd)?
when you create a database how is it stored? : Sql server database administration
How to insert multiple rows with a subquery?
How can we migrate from SQL server to SQL Azure?
What are “unrepeatable reads”?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
do you know how to configure db2 side of the application? : Sql server database administration
Can we insert data into view sql server?
Can we insert data into a view?
Why use identity in sql server?
How can you check the level of fragmentation on a table?
define and explain the differences between clustered and non-clustered indexes.
What are the recovery models for a database?
How do I clean up sql server transaction log?
