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
- 11676 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
what are different types of backups available in sql server? : Sql server database administration
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
How to convert character strings into numeric values?
What is clustered vs nonclustered index?
What are the five characteristics of good data?
What are synonyms?
Why do we use stored procedures in sql server?
what are the critical issues you have resloved in your company
Can you tell me about the concept of ER diagrams?
What are the advantages of user defined function?
Differentiate sql server reporting services vs. Crystal reports?
What are ddl triggers and types of ddl trigger?
What are the fixed server level roles? : sql server security
Explain activity monitors
