| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Stefan Kuhn | Date: | April 14 2012 11:21am |
| Subject: | Re: Simple Query Question | ||
| View as plain text | |||
On Saturday 14 April 2012 09:51:11 Willy Mularto wrote: > Hi, > Please help what is wrong with this simple query "SELECT COUNT(key_agent) > total FROM agents_consolidated WHERE total = 180" Thanks. You need to use having instead of where, see the documentation. Stefan > > > > Willy Mularto > F300HD+MR18DE (NLC1725)
| Thread | ||
|---|---|---|
| • Simple Query Question | Willy Mularto | 14 Apr |
| • Re: Simple Query Question | Stefan Kuhn | 14 Apr |
| • Re: Simple Query Question | Willy Mularto | 14 Apr |