SELECT REGION FROM T2 T2 INNER JOIN T1 T1 ON T1.EMPID = T2.EMPID INNER JOI

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

Please Help Members By Posting Answers For Below Questions

Explain the steps to create and execute a user-defined function in the sql server?

970

How to remove duplicate rows from table?

1250

Explain the properties of a relational table?

1024

What is difference between rownum and row_number?

968

What is application role in sql server database security? : sql server security

1057

What is difference between views and tables?

1010

What are the different types of data sources in ssrs?

196

Can sql servers link to other servers like oracle?

842

What is save transaction and save point?

1202

Where the sql logs gets stored?

986

Explain the working of sql privileges?

1093

What is t-sql script to take database offline – take database online.

1087

Would you store your query in a ssrs report or a database server? State the reason why?

152

What is a ddl statement?

913

What is the architecture of ms sql reporting service?

985