how to query this ??
Posted: Mon Jun 18, 2007 12:55 am
Hello forums !!
I would like to know how to count the no of fields that has specific values.
for example:
"table1" has field called "filed1" and it has values
------
|field1|
-------
|X |
|X |
|Y |
| X |
:
:
etc
I would like to know the no of rows that has the value X using count...
How to perform such query..
thanks in advance to all of you
I would like to know how to count the no of fields that has specific values.
for example:
"table1" has field called "filed1" and it has values
------
|field1|
-------
|X |
|X |
|Y |
| X |
:
:
etc
I would like to know the no of rows that has the value X using count...
How to perform such query..
thanks in advance to all of you