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
- 16805 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / manisha
select b.region from table1 as a,table2 as b
where a.employeeid=b.employeeid and a.[tshirt size]=3
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What are sql azure firewall rules?
Explain the various types of concurrency problem?
What is the purpose of floor function?
What do you need to connect php to sql server?
Explain what are page splits? : SQL Server Architecture
Explain features and concepts of analysis services?
Define Business Edition in SQL Azure?
What is partition, how will you implement it? : sql server analysis services, ssas
What are different types of roles provided by ssrs?
What is sub-query in sql server? Explain its properties.
Explain the concept of recursive stored procedure.
Which is the latest version of sql server and when it is released?
When would you prefer to have a minimum number of indexes?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is the syntax for encrypting a column in SQL Server?
