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
- 12605 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 a scheduled job or what is a scheduled task?
Why use identity in sql server?
What is an indexed view?
Why we use the openxml clause?
What is self contained sub query?
How do I start sql server 2017?
How to convert numeric expression data types using the cast() function?
What is the difference between for xml raw and for xml auto?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the different subsets of sql?
How to connect php with different port numbers?
What is in place upgrade in sql server?
What is a view in sql?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How to enter binary string literals in ms sql server?
