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

What actions will occur, when a Component Interface (CI) is created on component that has Add action enabled?

1 Answers  


A clients App was 3months behind, what should he do to update the app since it was not working?

1 Answers  


What is difference between trlate table and prompt table?

0 Answers  


The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions?

1 Answers  


What are the different types of matching in ap(2,3,4 amd receipt only matching)? Explain them?

0 Answers  


What are the purpose of all and none functions?

0 Answers  


Explain what are the think-time functions?

0 Answers  


Explain the major differences between peoplesoft versions hrms8.8 and hrms8.9? Explain with one example?

0 Answers  


State Record can be Dynamic Record?

1 Answers  


Which language technology is used in app messaging?

0 Answers  


What is the difference between chartfield and chart of accounts?

0 Answers  


WorkItem is available in?

1 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)