Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1199 Views
- I also Faced
- E-Mail Answers
Answer Posted / praveen
HAVING CRITERIA 18.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain about self service transactions?
Where people codes get stored?
Explain difference between saveprechanges and savepostchanges with respect to save edit?
Tell me how did you apply your patces and bundles?
Explain business unit with two different examples?
What is a business unit?
What is the process flow in billing, ar, am. Gl, ap, po etc?
Do you know how is an establishment different from a company?
What happens if you don't declare a variable?
Explain how to define the names of the application servers being used to access peoplesoft?
What are the different action types in peoplesoft?
How to define the names of the application servers being used to access peoplesoft?
What is the component processor?
What are the different ways to run ae, sqr?
Explain the difference between saveprechanges and savepostchanges with respect to save edit?
