| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Neil Tompkins | Date: | November 22 2012 5:05pm |
| Subject: | Re: Basic SELECT help | ||
| View as plain text | |||
When trying this query I get FUNCTION id does not exist On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman <mdykman@stripped> wrote: > select id from > > (select distinct id, count(*) > > from my_table > > where type in (2,5) > > group by id > > having count(*) = 2)a; >
| Thread | ||
|---|---|---|
| • Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | Mike OK | 22 Nov |
| • Re: Basic SELECT help | marek gutowski | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | Benaya Paul | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • RE: Basic SELECT help | Jason Trebilcock | 22 Nov |
| • Re: Basic SELECT help | Michael Dykman | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | Michael Dykman | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | Neil Tompkins | 22 Nov |
| • Re: Basic SELECT help | hsv | 22 Nov |
| • Re: Basic SELECT help | Mogens Melander | 22 Nov |
| • Re: Basic SELECT help | Mogens Melander | 22 Nov |
| • Re: Basic SELECT help | Michael Dykman | 22 Nov |
| • Re: Basic SELECT help | hsv | 23 Nov |
| • Re: Basic SELECT help | Shawn Green | 19 Dec |
