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

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2313


How many ways a relational source definition can be updated and what are they?

952


How do you load alternate records into different tables through mapping flow?

1802


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4035


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1095


Explain in detail scd type 2 through mapping.

986


Briefly define reusable transformation?

1075


What is aggregate cache in aggregator transformation?

1061


What is meant by target load plan?

914


Explain the types of transformations?

1005


How to generate sequence numbers using expression transformation?

1026


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1200


Explain scd type 3 through mapping.

916


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1628


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2099