>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?
SELECTCOUNT(*) FROM mytable WHERE field1 > 7
* orif you want to exclude records withnullin the field from the countSELECTCOUNT(SomeFiled) FROM mytable WHERE field1 > 7