Article:
  SQL Subqueries
Subject:   Count the number of record first existing in table at a date
Date:   2006-12-13 05:39:38
From:   jmtsnprn
Response to: Count the number of record first existing in table at a date

the query could be:
select count(fielda) from table where fieldb = '2005-02-10'