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
- 12351 Views
- I also Faced
- E-Mail Answers
Answer Posted / saravanan p
select e.empid,e2.region from empAge1 e,empAge2 e2
where e.empid=e2.empid and e.age in(select max(age) from
empAge1)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is user-defined inline table-valued function?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What are a database and a data warehouse?
How to execute the cursor queries with "open" statements?
how many no of arguments can be passed in procedures and functions
List out the differences between global and local temp tables in sql server?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is an expression in ms sql server?
How to disconnect from a sql server using mssql_close()?
How to round a numeric value to a specific precision?
What are the different Topologies in which Replication can be configured?
How do you troubleshoot errors in a SQL Server Agent Job?
What are two difference between sql azure and azure tables?
What is index fragmentation in ms sql server?
