>I want to count the number of records in one field base on some condition (let's say field1>7)
>How should I do it?

SELECT COUNT(*) FROM mytable WHERE field1 > 7 
* or if you want to exclude records with null in the field from the count
SELECT COUNT(SomeFiled) FROM mytable WHERE field1 > 7