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 biggest drawback to fieldformula?
Tell me in which one of the following views would you see the fields, criteria, and other details associated with the current query?
Leave went into lop(scenarios based fit gap) requirement phase is?
How to test an application engine program in 8.8?
Do you know triggerbusinessevent is used for triggering the workflow and its written on workflow event. Triggerbusinessevent has the syntax?
Difference between saveedit and fieldedit?
Explain where is unicode used?
Tell me how did you apply your patches and bundles?
How to delete a file using sqr?
Difference between winmessage and msgget functions?
Can you please explain the concept of control tables. List some of the key control tables?
Are disconnected mobile applications supported in peopletools 8.lx?
When workflow even fires?
What are the topics covered in people books?
When is peoplecode case sensitive?