List:General Discussion« Previous MessageNext Message »
From:Adam Williams Date:October 28 2009 4:33pm
Subject:Re: help with group by
View as plain text  
works perfectly, i didn't know you could use multiple columns in the 
group by.  thanks a bunch!

Michael Dykman wrote:
> try this:
>
> select accepted_by, problem_type, count(*) from form
> where problem_type is not NULL
> AND problem_type != 'Test'
> AND accepted_by is not null
> group by accepted_by, problem_type
>   

Thread
help with group byAdam Williams28 Oct
  • Re: help with group byMichael Dykman28 Oct
    • Re: help with group byAdam Williams28 Oct