Edit Question - KnowledgeHub

Title Body

Hi all I have a 'widget' table that has the following columns: widget, action, timestamp_. What we want to do is pull all the widgets that were rejected more than once a day between certain dates. So here's an example table widget action timestamp_ ------------------------------------------- type1 reject 2011-05-10 08:00:00 type1 reject 2011-05-10 09:00:00 type1 reject 2011-05-10 09:30:00 type2 reject 2011-05-11 09:30:00 type3 reject 2011-05-11 09:30:00 type1 reject 2011-05-11 09:30:00 type1 reject 2011-05-11 09:30:00 type2 reject 2011-05-12 10:30:00 type2 reject 2011-05-12 12:30:00 type3 reject 2011-05-12 12:30:00 So I anticipate wanting to see results in one of these two manners.... Between date x and y there were two widgets that were rejected multiple times in single days This would see that type1 was rejected more than once in a day as was type2 thus the count is: 2 OR Display each widget along with the date that it was rejected more than once and how many times. Example.. widget date count --------------------------------- type1 2011-05-10 3 type1 2011-05-11 2 type2 2011-05-12 2 This would probably be the preferred output... but how? Thanks in advance!

Tags (comma-separated) Cancel