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
- 12083 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
Can you explain full-text query in sql server?
Can I work with several databases simultaneously? : sql server management studio
What is the difference between a unique key and primary key?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
what is a self join? Explain it with an example? : Sql server database administration
explain different types of cursors? : Sql server database administration
How to recompile stored procedure at run time?
What are subqueries in sql server?
In which sql server version report builder introduced?
What is table level trigger?
What is purpose of normalization?
What are the various editions of sql server 2017 that are available in the market?
What is difference statement and preparedstatement?
How to insert a new row into a table with "insert into" statements in ms sql server?
What is the difference between a function and a stored procedure?
