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
- 17443 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 is user-defined inline table-valued function?
How to filter records of table in SQL SERVER?
Explain the relational database management system (rdbms)?
Define msdb database?
Difference between 2NF &3NF ?
Can we add an identity column to decimal datatype?
Does index slows down insert statements?
What are the transaction properties?
What is cdc in sql server?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is #temp and @table variable in SQL server?
What are the advantages of partitioning?
What are “lock” hints?
what is an extended stored procedure? : Sql server database administration
Is it safe to delete log files?
