SELECT REGION,AGE, T1.EMPID FROM T2 INNER JOIN T1 ON T1.EMPID = T2.EMPID W

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

Question Posted / monal

10 Answers
11666 Views
I also Faced
E-Mail Answers

Answer Posted / monal

SELECT REGION,AGE, T1.EMPID FROM T2 INNER JOIN T1
ON T1.EMPID = T2.EMPID WHERE AGE = (SELECT MAX(AGE) FROM T1)

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is change data capture (cdc) in sql server 2008?

976

If the job running very slow what is the action you do

1821

What is it’s similarity with sql server?

160

Is BCNF better than 2NF & 3NF? Why?

1002

How do you drop an index?

861

How do you troubleshoot errors in a SQL Server Agent Job?

1004

What is the sql server 2000 version number?

1007

Explain indexes disadvantages?

1009

What is the definition for sql server 2000?

1037

What is the use of RDBMS?

956

List out what other servers you can use with ssrs?

130

What is difference between count (*) and count column?

838

What do you do in data exploration

926

What is your recommendation for a query running very slow? : sql server database administration

992

What is difference between foreign key and unique key?

960