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
- 11933 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 alternate key, candidate key and composite key in sql server?
Mention a few common trace flags used with sql server?
Explain collation?
How to find table changes in sql server?
Explain the disadvantages of cursors?
What is raid? : SQL Server Architecture
What is triggers and its types?
What are horizontal and vertical scaling?
explain different types of constraints? : Sql server database administration
What is difference between createstatement and preparedstatement?
How to update multiple rows with one update statement in ms sql server?
What is updatable resultset?
Explain candidate key, alternate key, and composite key?
Is it possible for a stored procedure to call itself or recursive stored procedure?
Where are sql server user names and passwords stored in sql server?
