List:General Discussion« Previous MessageNext Message »
From:Graeme B. Davis Date:March 1 2000 11:03pm
Subject:COUNTing
View as plain text  
Is there any way to do something like: (psuedocode follows)

SELECT count(medium='Phone'), count(medium='Email') FROM table GROUP BY
person

basically I want to accomplish:

SELECT count(medium) FROM table WHERE medium='Phone' GROUP BY person;
SELECT count(medium) FROM table WHERE medium='Email' GROUP BY person;

in one statement...

is this possible?


Thanks!

Graeme

Thread
COUNTingGraeme B. Davis2 Mar
  • Re: COUNTingJonathan Stimmel2 Mar
  • Re: COUNTingGraeme B. Davis2 Mar
    • RE: COUNTingNicolas Prade2 Mar