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
What are the topics covered in people books?
what is deferred processing?
Suppose if you change the long name of translate field what object to be altered?
The example below demonstrates the use of sqr flags in the configuration manager directories folder: -f c:psllrmssqr what do the above sqr flags signify to the sqr report writer upon execution?
Which of the following commands can be run in bootstrap mode?
Different ways of setting up an hrms system to make it position driven?
What are the outputs of sqr?
Which language technology is used in app messaging?
What is paycycle?
When workflow even fires?
How to debug ae?
Explain about self service transactions?
What is record. Row peoplecode?
How will you get a single output by combining two or more queries?
What is a bundle?