Answer Posted / anil panwar

Hi Shivaraj
the ans you have given that is correct but
anyway,
if different employee id have same age and different region
and region is null in that case will not show Null region
for that employee


it may be solution....

select t1.id, t2.region from t1 left outer Join t2
on t1.id=t2.id
where t1.id in (select id from t1 where age=(select max(age)
from t1)) group by t1.id, t2.region

What is sql server programming?

1090

---

What is sqlservr.exe - process - sql server (sqlex?press)?

1154

---

Introduction of rollup clause using sum and group by clause?

1011

---

What is the need for group functions in sql?

1153

---

What are the five characteristics of good data?

971

---

Can you explain different types of locks in sql server?

992

---

Explain boyce and codd normal form(bcnf)?

1012

---

What type of locking occurs during the snapshot generation? : sql server replication

1373

---

What is difference between createstatement and preparedstatement?

1173

---

Is sql server 2016 free?

979

---

Where are stored procedures in sql server?

1124

---

Explain transaction server isolation?

1083

---

Can you explain what is indexed view? How to create it?

948

---

After removing a table from database, what other related objects have to be dropped explicitly?

1102

---

Can we write ddl in trigger?

969

---