Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Tell me one complex query in oracle ?

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


Please Help Members By Posting Answers For Below Questions

State the differences between sql override and lookup override?

1146


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1534


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6080


What are the databases that informatica can connect to windows?

1021


What is the status code in stored procedure transformation?

1140


What is olap (on-line analytical processing?

1031


What are the different clients of powercenter?

1021


What is the Process to creating lookup transformation in informatica

1003


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1890


What is the scenario which compels informatica server to reject files?

1026


What is an expression transformation in informatica?

984


Why is sorter an active transformation?

1077


What is target load order?

1205


How do you migrate data from one environment to another?

1067


Mention a few design and development best practices for informatica?

958