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
- 9531 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
Is it safe to delete log files?
How to find Duplicate Records In table?
What are the differences between decimal and float in ms sql server?
Can we use where and having clause together?
What is function of ROLLUP ?
What is the order by used for?
How do I view a trc file?
What are the properties and different types of sub-queries?
How you can get a list of all the table constraints in a database? : Sql server administration
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
How to create view in stored procedure sql server?
What are approximate numeric data types in ms sql server?
What is the need for group functions in sql?
Why do we need different type of parameter?
How can we check the sql server version?
