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
11669 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 does set rowcount do?

865

What is self contained scalar sub query?

924

What is xml datatype?

1028

How to download microsoft sql server 2005 express edition?

974

What is the rdl file?

123

What is the default fill factor value?

1010

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1010

How to create “dependant” parameter “make, model, year”

122

What is measure group, measure? : sql server analysis services, ssas

959

How do I view a script in sql server?

975

Is it possible to call a stored procedure within a stored procedure?

913

How is sql server used?

905

Characterize join and name diverse sorts of joins?

907

Does partitioning help performance?

886

How do I connect to sql server database?

948