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
- 16607 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
How to drop an existing table with "drop table" statements in ms sql server?
How to update a field in SQL after ALTERING a row?
What is the difference between set and select?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is the index requirement in SQL Azure?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What is the difference between value type and reference type?
What have included columns when we talk about sql server indexing?
What is awe?
How do I find the query plan in sql server?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
how would you improve etl (extract, transform, load) throughput?
How do I find sql server instance name?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
What are the tools available in market as an alternative to sql server reporting services?
