Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12352 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
what are user defined datatypes? : Sql server database administration
How to receive returning result from a query?
What does it mean if @@cursor_row returns a negative number?
What is cached report?
How do you delete duplicate rows in sql server?
What to check if a User database is locked?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is 3nf normalization?
What are unicode character string data types in ms sql server?
what kind of lan types do you know? : Sql server database administration
How do you create a clustered index?
Where do we use trace frag?
What are truncate options available in sql server? : sql server database administration
What is key attribute?
Can you create a logon trigger in sql server 2005 express edition?
