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
- 12056 Views
- I also Faced
- E-Mail Answers
Answer Posted / devendra sharma
select ID, region from tab1 where ID in
(select ID from tab2 where isnull(age,0)=(select max(age)
from tab2))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the optimization being performed in oracle and SQL Server?
Explain what are commit and rollback in sql?
what is blocking? : Sql server database administration
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is Federation and Federation Member?
Do you know what is a trace frag? Where do we use it?
Tell me what is de-normalization and what are some of the examples of it?
How to connect ms access to sql servers through odbc?
What are two difference between sql azure and azure tables?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are the built in functions in sql server?
What is role playing dimension with two examples? : sql server analysis services, ssas
Difference between 2NF &3NF ?
What are the advantages of using stored procedures in sql server?
