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
- 12602 Views
- I also Faced
- E-Mail Answers
Answer Posted / devendra sharma
select ID, region from tab1 where ID in
(select ID from tab2 where isnull(age,0)=(select max(age)
from tab2))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a view in sql?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the different subsets of sql?
what is the difference between openrowset and openquery?
How to convert character strings into numeric values?
How raid can influence database performance?
Can we do dml on views?
When should you use an instead of trigger?
How do I find the sql server version?
How to rebuild the master database?
Why we use the openxml clause?
do you know how to configure db2 side of the application? : Sql server database administration
What is the difference between for xml raw and for xml auto?
What is clustered index
Why should you use or avoid select * statements?
