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
- 12355 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
How to enable tcp/ip protocol on a sql server?
What is the use of sign function?
What causes index fragmentation?
What is a partitioned view?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is data compression? : sql server database administration
Explain can SSRS reports Cache results?
What is a trigger in sql server?
How do I start sql server agent automatically?
What is 4nf in normalization form?
How to use go command in "sqlcmd"?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Explain the difference between control flow and data flow?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What are the new features are introduced in sql server 2012 reporting services?
