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
- 12064 Views
- I also Faced
- E-Mail Answers
Answer Posted / gayathri
create table Emp1(EmployeeId int, Age int);
INSERT into Emp1 Values(1,20);
INSERT into Emp1 Values(2,20);
INSERT into Emp1 Values(3,25);
INSERT into Emp1 Values(4,25);
INSERT into Emp1 Values(5,30);
INSERT into Emp1 Values(6,30);
INSERT into Emp1 Values(7,30);
create table Emp_details(EmployeeId int, Region cahr(10));
INSERT into Emp_details Values(1,'del');
INSERT into Emp_details Values(2,'chn');
INSERT into Emp_details Values(3,'mum');
INSERT into Emp_details Values(4,'del');
INSERT into Emp_details Values(5,'cal');
INSERT into Emp_details Values(6,'mum');
INSERT into Emp_details Values(7,'chn');
select Region from Emp_details ed,Emp1 e1
where e1.EmployeeId = ed.EmployeeId
and e1.Age = (select max(Age) from emp1);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to avoid cursors? : Sql server database administration
Can a cursor be updated? If yes, how you can protect which columns are updated?
what is datawarehouse?
What is the difference between functions and scalar functions?
What is simple indexing method?
What are the restrictions while creating batches in sql server?
What are acid properties of transaction?
What options are available to audit login activity? : sql server security
How to select some specific columns from a table in a query in ms sql server?
How to create a testing table with test data in ms sql server?
Difference between uniqe index and uniqe constraint?
What is the importance of a recovery model?
What are the differences between char and nchar in ms sql server?
what is denormalization? : Sql server database administration
Explain what are the database objects? : SQL Server Architecture
