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 is the performance tuning of sqr?
Leave went into lop(scenarios based fit gap) requirement phase is?
Do you know when should be position management be preferred?
What are the new features in security in 8.0?
Suppose if you change the long name of translate field what object to be altered?
Explain file formats for file layout?
Difference between prebuild and postbuild?
Explain about control table?
What is customer connection?
What are the record field events?
How did you apply your patches and bundles?
Which of the following menu options allows you to modify the last process instance number used within the system?
What does update and fixes: r_* files refer?
Explain about self service transactions?
How to views two program of ae program?