Hello,



We have a table Sales with the following information.





SDate Salesrep Item_Sold



01/01 A Item X

01/01 A Item B

01/01 A Item C

01/01 B Item X

01/01 B Item Y

01/01 C Item Z



02/01 B Item B



02/01 B Item Y

02/01 C Item Z





HOw can i query this requirement?



how many sales reps had atleast one sale on a given day.





Date Count



01/01 3 (A, B AND c)



02/01 2 ( B and C)



etc ...





Thank you

Ganapathi



**********************************************************************************************
IMPORTANT: The contents are intended for the named recipient(s) only and may contain information that is
PRIVILEGED and/or CONFIDENTIAL.
If you have received this email in error, please destroy all copies of this message and it's attachments and
then notify the system manager or the sender immediately. Do not disclose the contents to anyone or make
copies thereof.
*** eSafe scanned this email for viruses, vandals, and malicious content. ***
**********************************************************************************************

Oracle LazyDBA home page