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
- 12604 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
SELECT REGION,AGE, T1.EMPID FROM T2 INNER JOIN T1
ON T1.EMPID = T2.EMPID WHERE AGE = (SELECT MAX(AGE) FROM T1)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is a scheduled job or what is a scheduled task?
Why we use the openxml clause?
How efficient you are in oracle and SQL server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is acid mean in sql server?
Disadvantages of the indexes?
Does view occupy space?
what is spatial nonclustered index
Why and when do stored procedure recompile?
Where can you add custom error messages to sql server?
What is a coalesce function?
How to provide default values to function parameters?
What is clustered index
What is sql server query analyzer?
