|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
May 21st, 2003, 04:14 PM
|
|||
|
|||
|
SELECT COUNT() question
I'm trying to count non-blank rows in a table, and everything I've found points to using a
SELECT COUNT(fieldName) FROM databaseName query. Can someone tell me how to return the value I'm looking for (the number of non-blank records for that particular field)? Thanks, --Joe
|
|
#2
May 21st, 2003, 05:06 PM
|
|||
|
|||
|
RE: SELECT COUNT() question
This should work. If you don't allow NULLs replace it with the default value.
|
|
#3
May 21st, 2003, 05:58 PM
|
||||
|
||||
|
RE: SELECT COUNT() question
SELECT COUNT(fieldName) FROM databaseName WHERE fieldName IS NULL;
and SELECT COUNT(fieldName) FROM databaseName; should return the same number since COUNT() only counts non-NULL values. The reason this might not work for you is that NULL and blank can be different. In that case, change the WHERE cluase to be something like LENGTH(fieldName) > 0
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > SELECT COUNT() question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
