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?
- 1 Answers
- 1255 Views
- I also Faced
- E-Mail Answers
Explain tuning can be done on which servers?
How does savepostchg differ from all other peoplecode events?
Where do you set people code trace?
With reference to the Component Interface Tester what is the purpose of GetExisting option?
What is record. Row peoplecode?
What are the outputs of sqr?
The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions?
What are the triggers in a component?
If you change the long name of translate field what object is to be altered?
Why temp records are needed?
Let us take a Temp Table TMP_TAO. In People Tools options the following instance settings are done Temp Table Instances (Total) : 5 Temp Table Instances (Online): 4 In AE1 App Engine Program the instance count to TMP_TAO is 3 In AE2 App Engine Program the instance count to TMP_TAO is 5. How many instances are created to TMP_TAO ?
Where do u set the web server cache?
PeopleSoft HRMS 
