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
- 16406 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 a view in sql?
Explain the difference between clustered and non-clustered index?
What information is maintained within the msdb database?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
How to throw custom exception in Stored Procedure?
What is exporting and importing utility?
How to create database with physical files specified in ms sql server?
How do I find the sql server instance name?
Describe in brief sql server monitoring ways.
How to loop through result set objects using odbc_fetch_row()?
How to use order by with union operators in ms sql server?
List all types of constraints in sql server?
Can we call future method from queueable?
What is deploy, process and build? : sql server analysis services, ssas
Explain a checkpoint?
