JadedLucidity Posted February 7, 2007 Share Posted February 7, 2007 I'm hoping someone can help me with this. I have a table with three columns 1 - auto indexed number 2 - product number (repeats depending on date) 3 - date so product 123 was sold on January 1, 2005, 8:30 AM and again on January 1, 2006, 9:15 PM etc etc etc. Lots of duplicates How do I query to just say product 123 had 15 sales between January 1, 2005 and January 1, 2006. Is there a way just to count how many between two dates and then export this report directly to excel? So it would be: Product id Number of sales 123 15 124 12 Something like that. Are there any tutorials on this? Thanks Link to comment https://forums.phpfreaks.com/topic/37550-mysql-export-issue/ Share on other sites More sharing options...
artacus Posted February 8, 2007 Share Posted February 8, 2007 SELECT product_no, COUNT(*) AS num_sold FROM sales WHERE the_date BETWEEN '2005-01-01' AND '2006-01-01' GROUP BY product_no Link to comment https://forums.phpfreaks.com/topic/37550-mysql-export-issue/#findComment-179640 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.