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
- 11686 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
Where sql server user names and passwords are stored in sql server? : sql server database administration
How do I view a stored procedure in sql server?
What is the difference between cartesian product and cross join?
Differentiate between SQL and ORACLE joins and write their syntax.
Do you know what is sql injection?
Explain the difference between control flow and data flow?
How many types of objects are there?
What are key constraints?
Explain hostprotectionattribute in sql server 2005?
Explain the various types of concurrency problem?
How do I find the size of a sql server database?
How to automatically create a log when an exception is being received into SQL Server?
Do you have any idea about the tcl commands?
Define magic tables in sql server?
Name three of the features managed by the surface area configuration tool? : sql server security
