Answer Posted / mahaboob basha
select users.user_id, users.email, max(classified_ads.posted)
from users, classified_ads
where users.user_id = classified_ads.user_id
group by users.user_id, users.email
order by upper(users.email);
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
State the differences between sql override and lookup override?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the databases that informatica can connect to windows?
What is the status code in stored procedure transformation?
What is olap (on-line analytical processing?
What are the different clients of powercenter?
What is the Process to creating lookup transformation in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is the scenario which compels informatica server to reject files?
What is an expression transformation in informatica?
Why is sorter an active transformation?
What is target load order?
How do you migrate data from one environment to another?
Mention a few design and development best practices for informatica?