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
- 12049 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
Explain Normalization and DE normalization
What is update locks?
Explain the steps to create and execute a user-defined function in the sql server?
What is dbcc command in sql server?
What does <> symbol mean?
What is service broker? : sql server database administration
Does group by or order by come first?
what is a traditional network library for sql servers? : Sql server database administration
How do you create an execution plan?
What is snapshot parameter in ssrs?
Why we use trigger in sql server with example?
State a few properties of relational databases?
Does the order of columns in update statements matter?
What is rank function?
What is a fan-out query in SQL Azure?
