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
- 9511 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
SELECT REGION FROM T2 T2 INNER JOIN
T1 T1 ON T1.EMPID = T2.EMPID INNER JOIN
(SELECT MAX(AGE) AGE FROM T1) TBLAGE ON T1.AGE = TBLAGE.AGE
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What protocol does sql server use?
Do you know clustered and non-clustered index?
please differentiate between delete and truncate?
What is the purpose of optimization?
What is the difference RDBMS and Graph Database?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What are a scheduled jobs?
What are different backups available in sql server?
Can we store videos inside the sql server table?
Explain following error properties?
What is user-defined scalar function?
What sql server means?
Define outer join?
What is raid? : SQL Server Architecture
What is the difference between insensitive and scroll cursor?
