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
- 16428 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
How to return the second 5 rows in ms sql server?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
what is hash nonclustered index
What are cursors in ms sql server?
What is the use of for clause?
How to find index size for each index on table?
Determine when an index is appropriate?
How to use the inserted and deleted pseudo tables?
Please explain what is “asynchronous” communication in sql server service broker?
How to use wildcard characters in like operations in ms sql server?
explain declarative management framework (dmf) in sql server 2008?
How do you start single user mode in clustered installations?
Do you know concepts and capabilities of sql server?
List some major differences between triggers and stored procedures?
Explain the Ways to improve the performance of a sql azure database?
