GeekInterview.com
Series: Subject: Topic:
Question: 66 of 201

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?

HAVING CRITERIA 18.
Asked by: Interview Candidate | Asked on: Sep 4th, 2004

This Question is not yet answered!

Related Open Questions

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.