<pre>SELECT COUNT(A) FROM X WHERE A='TREK';</pre>
is the usual way, and also the most efficient.
If you want to do several independent counts of the same table in one query, you can do something like this:
SELECT SUM (
WHEN a = 'TREK'
) AS a_trek
, SUM (
WHEN b = 'FOO'
) AS b_foo
WHERE c = 'FIRBOLIG';
Last Wiki Answer Submitted: March 4, 2008 9:20 pm by Buddyfarr6,850 pts.