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
- 770 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
Tell me data mover questions. Where did you use etc?
Which of the above record definitions is not stored on the database and therefore not required to build?
Where do you set people code trace?
Explain about translate tables?
Where do we find the doc /// in customer connection---frequently updated. Thing like patches?
Difference between sqlexec and createsql?
Define transferpage () with syntax ?
Leave went into lop(scenarios based fit gap) requirement phase is?
Explain difference between saveprechanges and savepostchanges with respect to save edit?
Define pc editor?
What is record. Row peoplecode?
Explain where do we find the doc /// in customer connection---frequently updated. Thing like patches?
Explain the application server dynamically scales server processes according to the volume of transaction requests? Which is known as?
Tell me for self service transactions what are the delivered approver options and where are they setup?
Explain the various ways to run sqr?
