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
- 11919 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 is the difference between ‘having’ clause and a ‘where’ clause?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Name and describe few console utilities for ssrs?
What is the return type of executeupdate ()?
What happens if null values are involved in string operations?
How to test subquery results with the exists operator?
Why are you getting errors when creating a new odbc dsn?
What is federation member?
What happens if the update subquery returns multiple rows in ms sql server?
How to generate random numbers with the rand() function in ms sql server?
What is the recommended total size of your memory optimized tables?
What are exact numeric data types in ms sql server?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What’s the distinction between dropping a info and taking a info offline?
How to download and install the scaled-down database adventureworkslt?
