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
- 12350 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
what are the types of indexes? : Sql server database administration
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How to delete existing rows in a table?
What are locks in sql?
define and explain the differences between clustered and non-clustered indexes.
How to create a Master database in SQL server ?
What is difference between rownum and rowid?
What do you understand by sql server agent?
Is it possible for a stored procedure to call itself or recursive stored procedure?
How to list all user defined functions in the current database?
What are the different types of cursor?
Do you know hot add cpu in sql server 2008?
What are the properties of the relational tables?
What is normalization of database?
Explain stored procedure?
