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
- 16802 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 exporting utility?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What is the xml datatype?
How to find out what is the default collation in a database?
Scalability, Availability, Integration with internet, etc.)?
What are the fixed server level roles? : sql server security
Is it possible for a stored procedure to call itself or recursive stored procedure?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
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?
What is the return type of executeupdate ()?
How do you start single user mode in clustered installations?
What is a cursor, index in sql?
If no size is defined while creating the database, what size will the database have?
What is report server project?
What is policy based management (pbm)? : sql server database administration
