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!
advertisement

Article:
  SQL Subqueries
Subject:   Count the number of record first existing in table at a date
Date:   2007-12-17 02:49:44
From:   Aryanrules
Response to: Count the number of record first existing in table at a date

Hi Devil,
its simple man
I think by this time you might hv got the answer if not use this query


SELECT * FROM table_name where fieldB ='2/10/2005' LIMIT 2


regards,
Aryan