get a row count

[QAteste]

From the DB2 command window how can I get a count of rows matching a particular expression. Here is my select statement and I saw something in the forum about a select count(*) but was unsure how to use it. Thanks in advance!!!

select * from db2admin.hit_facts where gmttimofday_id > 3359 and gmttimofday_id < 7200

 

[gregsimpson]

Your almost there, simply missed the count off.

Try the following

select count(*)
from db2admin.hit_facts
where
gmttimofday_id > 3359 and
gmttimofday_id < 7200


Cheers
Greg