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 / 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
Is it possible to update the views? If yes, how, if not, why?
How to provide default values to stored procedure parameters?
how to use DTS package in 2000,2005,2008 in sql server
What is the process of normalization?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What does truncate do?
What is difference between delete and truncate commands?
What is transactional replication?
When I run the sql server 2000 setup, it just hangs. What do I do?
How do I view a trc file?
Define tempdb database?
Is sql server a database?
What are the general features of sql server management studio? : sql server management studio
What is the use of keyword with encryption. Create a store procedure with encryption?
How many tables can be joined in SQL Server?