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
- 14120 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / sandeep narayanan
SELECT B.Region FROM TABLE1 AS A
INNER JOIN TABLE2 AS B ON A.EmployeeID=B.EmployeeID
WHERE A.TShirtSize=3
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is log in sql server?
What is best institute to Learn DotNET And SQL in chennai?
What are the fixed server level roles? : sql server security
What is the use of tempdb? What values does it hold?
What do you mean by an execution plan? Why is it used? How would you view it?
Where in ms sql server is ’100’ equal to ‘0’?
How is sql server used?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Why do we need normalization?
What stored by the master? : sql server database administration
How much does sql server 2016 cost?
What is wide table?
How will you know when statistics on a table are obsolete?
What are the dis_advantages of stored procedures, triggers, indexes?
Where sql server usernames and passwords are stored in a sql server?
