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
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
Differentiate sql server reporting services vs. Crystal reports?
What is the use of stored procedure?
Why variables called the most powerful component of ssis?
How does Report Builder support Analysis Services cubes?
Explain datetime2 data type in sal server 2008?
How to assign new column names in a view?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
How to create a user name in a database?
What is master database? : SQL Server Architecture
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Explain system rowset functions?
What are cursors stored procedures and triggers?
What is a group function explain with an example?
What are character string data types in ms sql server?
What part does database design plays a role in performance of an sql server-based application?