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
- 16994 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / ashok
select b.Region, a.TSize, Count(a.TSize)
as TSizecount from Table1 a,Table2 b where a.Empid =
b.Empid and a.TSize=3 group by region, TSize order by
Region, count(*), TSize desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain Reporting Life Cycle?
Create and insert into temp table in sql server?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What samples and sample databases are provided by microsoft?
How to check table values in sql server?
How do I get to sql server configuration manager?
How to query multiple tables jointly?
When is the use of update_statistics command?
Explain about protocol layer present in SQL server?
Do you know what is blocking?
How many instances per computer are there in sql server 2000?
How to configure odbc dsn with different port numbers?
what are the disadvantages of cursors? : Sql server database administration
Which tcl commands are available on the sql server?
What is the current limitation of the size of SQL Azure DB?
