haibec Posted July 11, 2007 Share Posted July 11, 2007 Hi all!I have a table Product include ID,ProductName,Price,RegDate. I want check total money with a ProductName everyday from 1/10/2007 to 7/10/2007.Plese help me Link to comment Share on other sites More sharing options...
vijay Posted July 16, 2007 Share Posted July 16, 2007 Hi.. you can use the follwoing query.. select sum(Price) as total,ProductName group by ProductName where RegDate >='1/10/2007' and RegDate <='7/10/2007'Regards,Vijay Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.