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 biggest drawback to fieldformula?

814


Tell me in which one of the following views would you see the fields, criteria, and other details associated with the current query?

766


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

775


How to test an application engine program in 8.8?

776


Do you know triggerbusinessevent is used for triggering the workflow and its written on workflow event. Triggerbusinessevent has the syntax?

817


Difference between saveedit and fieldedit?

771


Explain where is unicode used?

786


Tell me how did you apply your patches and bundles?

703


How to delete a file using sqr?

960


Difference between winmessage and msgget functions?

823


Can you please explain the concept of control tables. List some of the key control tables?

753


Are disconnected mobile applications supported in peopletools 8.lx?

715


When workflow even fires?

807


What are the topics covered in people books?

712


When is peoplecode case sensitive?

802