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
- 17016 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / ram
select region from tab2 where empid in(select empid from
tab1 where tshirtsize=3)
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
What new data source types were added in ssrs 2014?
How to find the list of fixed hard drive and free space on server?
explain databases and sql server databases architecture? : Sql server database administration
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Which Model uses the SET concept
what is the sql equivaent of the dataset relation object ?
What is replication and database mirroring?
What is a covering index?
Can an entity have two primary keys?
Difference between aggregate functions of sql?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Can we call stored procedure in trigger?
what is a live lock? : Sql server database administration
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Tell me can we use custom code in ssrs?
