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
- 1129 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
What are the different ways to run ae, sqr? (Command, process scheduler)
The field property is changed from prompt with no edit to prompt with edit. what is the effect. No more data edit possible?
What is file format for sqr?
Tell me what is record, row peoplecode?
What is the component processor?
What are the foundations classes which are useful to access component buffer?
Suppose if hr admin creates a person by error in peoplesoft, how can the person be removed from all key database tables using a delivered process?
Explain about control table?
Do you know what are the triggers in a component?
The example below demonstrates the use of sqr flags in the configuration manager directories folder: -f c:psllrmssqr what do the above sqr flags signify to the sqr report writer upon execution?
Suppose you just finished customization work that involved the creation of many new objects. You must now migrate these objects from your development database (source) to a testing database (target) to conduct more elaborate testing.referring to the above information, why would adding your objects to a project
Tell me what are the parameters that you will give for crystal reports?
If you change the long name of translate field what object is to be altered?
Tell me interlink data type can be declared as?
How is an establishment different from a company?
