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?



Suppose the CEO wants a list of the departments whose MINIMUM salary is greater than $100,000. Your ..

Answer / praveen

HAVING CRITERIA 18.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More PeopleSoft General Interview Questions

Explain file formats for file layout?

0 Answers  


What are the different action types in peoplesoft?

0 Answers  


Tell me what are the outputs of sqr?

0 Answers  


Give the command in order to start the Process Scheduler Server from the command line using psadmin.?

1 Answers  


Please differentiate between translate, processing, control and transaction tables?

0 Answers  


What are the differences between ae and sqr?

0 Answers  


How did you apply your patches and bundles?

0 Answers  


What is the purpose of state record?

0 Answers  


What are the triggers in a component?

0 Answers  


What is the use of scrollflush()

0 Answers  


Which ApiObject data type objects can’t be declared as Global:?

1 Answers  


If you change the long name of translate field what object is to be altered?

0 Answers  


Categories
  • PeopleSoft HRMS Interview Questions PeopleSoft HRMS (83)
  • PeopleSoft Financials Interview Questions PeopleSoft Financials (27)
  • PeopleSoft Administration Interview Questions PeopleSoft Administration (181)
  • PeopleSoft Tools Interview Questions PeopleSoft Tools (176)
  • PeopleSoft Interfaces Interview Questions PeopleSoft Interfaces (58)
  • Internet EBusiness Interview Questions Internet EBusiness (19)
  • PeopleSoft Implementation Interview Questions PeopleSoft Implementation (142)
  • PeopleSoft General Interview Questions PeopleSoft General (385)
  • PeopleSoft AllOther Interview Questions PeopleSoft AllOther (60)