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
- 11916 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil panwar
select t1.id, t2.region from table t1 left outer Join table2 t2
on t1.id=t2.id
where t1.id in (select id from table1 where age=(select
max(age) from table1))
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the return type of executeupdate ()?
How to attach adventureworkslt physical files to the server?
Can we insert data into a view?
What is isolation levels?
1 01 101 01010
What objects does the fn_my_permissions function reports on? : sql server security
What is index, cluster index and nonclustered index?
What is the maximum length of an alert name?
Is oracle faster than sql server?
Do you know what are pages and extents? : SQL Server Architecture
What is a not null constraint?
what kind of lan types do you know? : Sql server database administration
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Your table has a large character field there are queries that use this field in their search clause what should you do?
Explain SSRS Architecture?
