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
- 16593 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 is left outer join in sql server joins?
What are a database and a data warehouse?
How to view the error log for any specific instance? : sql server database administration
How to set database to be single_user in ms sql server?
What happens if you delete a table that is used by a view?
Which is the latest version of sql server and when it is released?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How to count duplicated values in a column in ms sql server?
What are different types of statements that are supported by sql?
How to convert numeric expression data types using the cast() function?
Do you think BCNF is better than 2NF & 3NF? Why?
List out the different types of locks available in sql server?
How do I find the sql server database version?
How to call stored procedure using http soap?
What is truncate table?
