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
12038 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 are the purpose of Normalisation?

1050

Â Explain what is sql override for a source taLle in a mapping?

1012

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

956

Why do you want to join software field as you have done your BE in Electronics?

2144

What is exporting and importing utility?

1085

Explain the commands in sql server?

1038

Explain datetimeoffset data type in sal server 2008?

907

Explain trigger classes i.e. Instead of and after trigger?

877

Indexes are updated automatically is the full-text index also updated automatically?

1029

What are the different normalization forms?

1110

What is resource governor?

973

What are exact numeric data types in ms sql server?

1074

What is sql server schema compare? How we can compare two database schemas?

1030

What is the template in sql?

978

Define self join in sql server joins?

948