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
- 11915 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
Do you know what is lock escalation?
How do I open port 1433?
What do you mean by subquery?
What is the use of stored procedure?
What are the differences between having and where clause.
What is a trigger in sql server?
What is difference between drop truncate and delete?
How do you create type- insensitive operator?
how you can move data or databases between servers and databases in sql server? : Sql server administration
How to create nested stored procedure?
What are the recovery models for a database?
Is it possible to have clustered index on separate drive from original table location?
How to include text values in sql statements?
How to find the source of a table in sql server?
What is candidate key with example?
