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
- 11670 Views
- I also Faced
- E-Mail Answers
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
How we create SQL Server 2005 Reporting Services ? Give me Sample
Define msdb database?
What is the difference between ‘having’ clause and a ‘where’ clause?
How to list all user defined functions in the current database?
Different types of keys in SQL?
What is Lock table in SQL?
How to create stored procedures with parameters in ms sql server?
What is cube dimension? : sql server analysis services, ssas
Can you explain about buffer cash and log cache in sql server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Explain what are the different index configurations a table can have?
what is a schema in sql server 2005? : Sql server database administration
What are the kinds of subquery?
What is sql server profiler?
How can you fetch alternate records from a table?
