Count the number of record first existing in table at a date

We've expanded our news coverage and improved our search! Visit news.oreilly.com for the latest or search for all things across O'Reilly!

Article:		SQL Subqueries
Subject:		Count the number of record first existing in table at a date
Date:		2006-10-29 01:25:20
From:		ramu82
Response to: Count the number of record first existing in table at a date
select distinct(field A) from date