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
- 16803 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / susanna
select top 1 Count(r.Empid) as Ct,r.regionId from Emp_Region
r inner join Emp_Tshirt t on r.Empid= t.EmpId
where t.T_size=3 group by r.regionId order by Ct desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
When you should use a low fill factor?
How to create new table with "create table" statements?
How to delete a database in ms sql server?
What is read uncmmited?
What is difference between delete & truncate commands?
How to modify the underlying query of an existing view?
What is a join in sql? What are the types of joins?
Do you have any idea about the tcl commands?
what are candidate key, alternate key and composite key? : Sql server database administration
How to filter records of table in SQL SERVER?
What are the mathematical functions supported by sql server 2005?
what is a check constraint?
What is single-user mode?
How to configure odbc dsn with different port numbers?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
