Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?



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

Answer / praveen

HAVING CRITERIA 18.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More PeopleSoft General Interview Questions

Update and Fixes: R-* files refers to?

1 Answers  


How do you retrieve a value from scroll.scroll select?

0 Answers  


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?

0 Answers  


How do you create the department security with navigations?

0 Answers  


How to test an application engine program in 8.8?

0 Answers  


what is deferred processing?

0 Answers  


how do you delete a file using sqr?

0 Answers  


What is the difference between sql statements and metasql statements?

0 Answers  


Explain file formats for file layout?

0 Answers  


Explain about processing tables?

0 Answers  


Which one of the following Data Types is NOT supported by the PeopleCode programming environment?

1 Answers  


What are Record field events ?

1 Answers  


Categories
  • PeopleSoft HRMS Interview Questions PeopleSoft HRMS (83)
  • PeopleSoft Financials Interview Questions PeopleSoft Financials (27)
  • PeopleSoft Administration Interview Questions PeopleSoft Administration (181)
  • PeopleSoft Tools Interview Questions PeopleSoft Tools (176)
  • PeopleSoft Interfaces Interview Questions PeopleSoft Interfaces (58)
  • Internet EBusiness Interview Questions Internet EBusiness (19)
  • PeopleSoft Implementation Interview Questions PeopleSoft Implementation (142)
  • PeopleSoft General Interview Questions PeopleSoft General (385)
  • PeopleSoft AllOther Interview Questions PeopleSoft AllOther (60)