Interested to Buy Any Domain ? << Click Here >> for more details...
please can anyone answer this query
Table 1 has 2 columns: EmployeeId,Age
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region who has the oldest person
- 10 Answers
- 12330 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
SELECT REGION FROM T2 T2 INNER JOIN
T1 T1 ON T1.EMPID = T2.EMPID INNER JOIN
(SELECT MAX(AGE) AGE FROM T1) TBLAGE ON T1.AGE = TBLAGE.AGE
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the concept of view and Types of views in SQL server?
Do you know spatial data types - geometry and geography in sql server 2008?
Will sql server 2005 allow you to reduce the size of a column?
What is the difference between push and pull subscription? : sql server replication
What do you understand by integration services in sql server?
Which tcp/ip port does sql server run on? How can it be changed?
Characterize join and name diverse sorts of joins?
Define normalisation?
what is a correlated sub-query? : Sql server database administration
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What does man by sql wildcard characters in sql server?
what are user defined datatypes? : Sql server database administration
How would you go about developing a ssrs report?
What is a benefit of using an after insert trigger over using a before insert trigger?
What is history table in sql server?
