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
12035 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

How to get @@error and @@rowcount at the same time?

1035

How do you drop an index?

922

What is meant by referential integrity?

1010

How you can minimize the deadlock situation?

1039

What the different types of Replication and why are they used?

1071

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1003

What is tablix?

162

Is foreign key unique?

995

What happens if you delete a table that is used by a view?

990

What are the advantages of having an index on the sql server?

925

What are the rendering extensions of ssrs?

157

How to drop an existing table?

1001

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1086

How to create new databases with "create database" statements?

1019

What does normalization do to data?

1065