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
- 12339 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
how to determine the service pack currently installed on sql server? : Sql server database administration
Find nth lowest salary or get nth lowest salary?
How to turn off warning messages during php execution?
How to get @@error and @@rowcount at the same time?
What do you mean by sql server agent?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What are the different authentication modes in sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
Explain what is the use of custom fields in report?
What are the disadvantages of primary key and foreign key in SQL?
can a database be shrunk with users active? : Sql server administration
Why do we use functions?
What is logon trigger?
Tell me what is log shipping?
