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

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

1 Answers  


Which of the following fires after the database is updated?

0 Answers  


The DB User mentioned in Connect ID should have permission to which Three PeopleSoft Tables?

1 Answers  


Where can you write the peoplecode?

0 Answers  


Difference between saveprechange and savepostchange?

0 Answers  


Explain how to debug ae?

0 Answers  


What is paycycle and paycycle manager?

0 Answers  


You have 3 App. Servers where do you define the Failover?

1 Answers  


Worklist for a particular user contains marked worked and reassigned buttons. The reassigned button is set from?

1 Answers  


State Record can be Dynamic Record?

1 Answers  


Suppose you just finished customization work that involved the creation of many new objects. You must now migrate these objects from your development database (source) to a testing database (target) to conduct more elaborate testing.referring to the above information, why would adding your objects to a project

0 Answers  


What is transaction tables?

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)