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
Data table as parameter in sql server?
How do you run a trace?
Explain in brief how sql server enhances scalability of the database system?
What is the index requirement in SQL Azure?
How do you test your database? : sql server database administration
What do you mean by an execution plan? Why is it used? How would you view it?
Where are sql server usernames and passwords stored in the sql server?
What is temporal data type?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Explain the usage of floor function in sql server.
How to get the definition of a stored procedure back?
What is wide table?
Which is faster statement or preparedstatement?
How to concatenate two binary strings together?
Explain various data region available in ssrs with their use?