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
12062 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 the distinction amongst delete and truncate?

1071

What are policy management terms?

987

What is named query? : sql server analysis services, ssas

971

Can a table be moved to different filegroup?

978

Can you import Microsoft Excel data to SSRS?

132

What is self join in sql server joins?

1067

What is an entity-relationship diagram (erd)?

1216

What are temporal tables in sql server 2016?

892

explain different types of joins? : Sql server database administration

990

What are the differences between web role and worker role?

122

What are the restrictions that views have to follow? : SQL Server Architecture

1006

What are the encryption mechanisms in sql server?

1032

Name three of the features managed by the surface area configuration tool? : sql server security

997

What are different types of roles provided by ssrs?

152

How the authentication mode can be changed?

1137