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...

Suppose the CEO wants a list of the departments whose MINIMUM salary is greater than $100,000. Your manager asks you to determine the quickest method to deliver this data to the CEO. Since writing an SQR will take too much time, you decide to use PeopleSoft query.Referring to the above, what function would you use, in combination with the aggregate function "Minimum" to produce the result set required?

Answer Posted / praveen

HAVING CRITERIA 18.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the performance tuning of sqr?

778


Leave went into lop(scenarios based fit gap) requirement phase is?

723


Do you know when should be position management be preferred?

730


What are the new features in security in 8.0?

679


Suppose if you change the long name of translate field what object to be altered?

688


Explain file formats for file layout?

780


Difference between prebuild and postbuild?

903


Explain about control table?

704


What is customer connection?

755


What are the record field events?

773


How did you apply your patches and bundles?

676


Which of the following menu options allows you to modify the last process instance number used within the system?

691


What does update and fixes: r_* files refer?

770


Explain about self service transactions?

719


How to views two program of ae program?

866