Thread: Need help w/ an SQL statement

I'm using the following sql statement to get a count on our business from repeat customers and would like to be able to specify a time frame (ie 3/01/10 - 3/31/10) but have been unsuccessful. What do I need to add to this?

SELECT Email,
COUNT(Email) AS NumOccurrences
FROM Orders
GROUP BY Email
HAVING ( COUNT(Email) > 1 )

Thanks in advance for your assistance!
David

I was able to accomplish by doing something like:

Code:

SELECT Email,
COUNT(Email) AS NumOccurrences
FROM Demo.dbo.Orders
Where AuthorizedOn BETWEEN '3/01/10' and '3/31/10'
GROUP BY Email
HAVING ( COUNT(Email) > 1 )