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
- 9518 Views
- I also Faced
- E-Mail Answers
Answer Posted / shivaraj
select region from table1 where employeeid in (select
employeeid from table2 where age in (select max(age) from
table2))
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to define output parameters in stored procedures?
What is use of except clause? How does it differ from not in clause?
What is the full form of dql?
Do you know spatial data types - geometry and geography in sql server 2008?
How can a user-defined datatype be created?
How you can minimize the deadlock situation?
What does <> symbol mean?
Can we use having clause without group by?
What is exporting and importing utility?
What is the language structure to add a record to a table?
Name and describe few console utilities for ssrs?
What are the different types of Indexes available in SQL Server?
How does a profiler work?
What is create statement?
Explain cdc and sql injection?
