Article:		SQL Subqueries
Subject:		Count the number of record first existing in table at a date
Date:		2007-01-22 08:13:14
From:		nikberry
Response to: Count the number of record first existing in table at a date
I haven't tried this, but something like: select fielda,fieldb from table where fieldb = '2/10/2005' and fielda not in( select fielda from table where fieldb < '2/10/2005')

Showing messages 1 through 1 of 1.

• Count the number of record first existing in table at a date
  2007-01-22 08:15:02  nikberry [Reply | View]
  
  
  Obviously you'd need count() too :).