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
- 17393 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / avaneesh bajoria
select top 1 t2.region , count(t1.tsize) as co from tsize
t1,region t2
where t1.empid = t2.empid
group by t2.region,t1.tsize
having t1.tsize = 3 order by co desc
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
Which command is used for user defined error messages?
What is multi-statement table-value user-defined function?
What is the difference between inner join and equi join?
What are the types of containers in ssis?
Why use “pivot” in sql server?
What is checkpoint process in the sql server?
What is the recommended total size of your memory optimized tables?
Explain transaction server auto commit?
How to connect of datebase with sql express.?
What are the built in functions in sql server?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is a constant or literal in ms sql server?
Can I use sql azure as a backup with log shipping or database mirroring?
Explain how you can configure a running aggregate in SSRS?
