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
- 17422 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
What structure can you implement for the database to speed up table reads?
What is sql server 2000 work load governor?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What are data driven subscriptions?
Explain the use of containers in ssis and also their types?
Name 3 ways to get an accurate count of the number of records in a table?
What method is used by the Command classes to execute SQL statements that return single values?
What is the function of inner join?
What is a sql join?
What is the current pricing model of SQL Azure?
Explain what is “asynchronous” communication in sql server service broker?
What is the difference RDBMS and Graph Database?
What is cte (common table expression)?
How do you delete duplicate records in sql server?
What is difference between count (*) and count column?
