select ID, region from tab1 where ID in (select ID from tab2 where isnull(

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 / devendra sharma

10 Answers
11920 Views
I also Faced
E-Mail Answers

Answer Posted / devendra sharma

select ID, region from tab1 where ID in
(select ID from tab2 where isnull(age,0)=(select max(age)
from tab2))

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is stored procedures?

1004

Explain the difference between cross join and full outer join?

966

Can a function call a stored procedure in sql server?

939

What is multi-statement table-value user-defined function?

979

What is the difference between index seek vs. Index scan?

1009

How many database files are there in sql server 2000?what are they?

1028

What are various ways to enhance the ssrs report?

968

What is etl - extraction, transformation, and loading?

902

Determine when to use stored procedure to complete sql server tasks?

1036

What is the name of reporting services config file and what’s it’s used for?

146

Explain what role entity and relationship play in an ER diagram.

1058

What are three major types of constraints?

1096

Explain where clause?

977

Can you name some of the dml commands in sql?

1010

What do you mean by SQL injection attack?

1041