Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10 Answers
- 11675 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does the unique constraint create an index?
What is difference between index and primary key?
Write a query for primary key constraint with identity key word?
How to test values returned by a subquery with the in operator?
What is key attribute?
What happens if null values are involved in arithmetic operations?
Why I have to use stored procedures?
Difference between primary key and clustered index?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Equi join and non equi join is possible with sql server?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How will you go about resolving deadlocks?
Is BCNF better than 2NF & 3NF? Why?
What are the difference between primary key and unique key? : sql server database administration
How can a database be repaired?
