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
- 9517 Views
- I also Faced
- E-Mail Answers
Answer Posted / devendra sharma
select ID, region from tab1 where ID in
(select ID from tab2 where isnull(age,0)=(select max(age)
from tab2))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to assign new column names in a view?
How many types of stored procedures are there in sql server?
What is a trace frag?
Explain a checkpoint?
What is a deadlock and what is a live lock?
application server is slow what may be the problem
How to access the inserted record of an event?
Do you know what is similarity and difference between truncate and delete in sql?
Explain how to integrate the ssrs reports in application?
What is 1nf 2nf and 3nf?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is data file in computer?
How many types of functions are there in sql server?
How raid can influence database performance?
How to get a list of columns in a view using the "sp_columns" stored procedure?
