Suppose the CEO wants a list of the departments whose MINIMUM salary is greater than $100,000 ...

PeopleSoft Interview Questions and Answers

(Continued from previous question...)

137. Suppose the CEO wants a list of the departments whose MINIMUM salary is greater than $100,000 ...

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?

HAVING CRITERIA 18.

(Continued on next question...)

Other Interview Questions

• Which of the following are Record field events ?
• Query is split into what?
• Trace 255 command line option produces the trace file with the name?
• Customization done in Dev DB, Which tool i will use to move it to Prod DB?
• PeopleSoft has its own naming convention for system and non-system (application) tables ....
• Which process is used for running AE programs which are to be run at a frequency of less than a day ?
• Which of the following are true with respect to validate signon with database option enabled in psadmin.?
• Use of process profile?
• In Two Tier mode where does authentication happens?
• What category of commands can be executed in data mover?
• More...