select region from table1 where employeeid in (select employeeid from t

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 / shivaraj

10 Answers
12034 Views
I also Faced
E-Mail Answers

Answer Posted / shivaraj

select region from table1 where employeeid in (select
employeeid from table2 where age in (select max(age) from
table2))

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the advantages of merge replication?

951

How to verify a user name with sqlcmd tool?

1080

What are the encryption mechanisms in sql server?

1028

What are the different types of collation sensitivity?

1121

Explain candidate key, alternate key, and composite key?

1003

Is candidate a key?

947

Explain timestamp datatype?

969

What is replication and database mirroring?

1047

How does index makes search faster?

979

How to automatically create a log when an exception is being received into SQL Server?

1287

How to change the password of a login name in ms sql server?

1013

How does recursive cte works in sql server?

1009

What are the purposes and advantages stored procedure?

959

What do you mean by an execution plan?

1115

How to insert data into an existing table?

977