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
- 12055 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil panwar
select t1.id, t2.region from table t1 left outer Join table2 t2
on t1.id=t2.id
where t1.id in (select id from table1 where age=(select
max(age) from table1))
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the fillfactor concept in indexes?
What are trace flags and mention a few common trace flags used with sql server?
How to restore performance issues and how to check?
What is trigger in salesforce?
List out some of the requirements to set up a sql server failover cluster?
What is table constraint?
How can I tell if sql server is 32 or 64 bit?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
How connect excel to sql server?
We need to perform what steps in the following order to work with a cursor?
What is shared lock?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Tell me can we use custom code in ssrs?
What is mean by candidate key?
What are sub reports and how to create them?
