|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
April 1st, 2004, 03:47 PM
|
|||
|
|||
|
HAVING question
Hello:
Does anyone know if it is possible to have to instiences of HAVING in a mysql query? "SELECT * FROM TABLE HAVING (THIS,THAT)" Would that be the correct way to do it?
|
|
#2
April 1st, 2004, 04:04 PM
|
||||
|
||||
|
RE: HAVING question
HAVING is like a WHERE clause but for aggregate columns.
For example, if you want to return a categories that appear at least 3 times, use something like: Code:
SELECT category FROM table_name GROUP BY category HAVING COUNT(*) >= 3 See MySQL's SELECT syntax page.
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > HAVING question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
