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
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
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
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 types of user defined functions in sql server?
How to display a past time in days, hours and minutes?
You want to implement the one-to-one relationship while designing tables. How would you do it?
what is a sub-report?
If user is owning any SQL Objects, can we drop that user
How do you delete duplicate records in sql server?
What is the difference between a check constraint and a rule?
What is query optimizer in sql server?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Differentiate between mongodb vs. Sql server?
What is a rownum?
Why are you getting errors when creating a new odbc dsn?
What is the process of normalization?