Women in Technology

Hear us Roar



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




Main Topics Oldest First

Showing messages 1 through 1 of 1.

  • Count the number of record first existing in table at a date
    2009-04-28 04:23:25  SCJPSandy [View]

    Hi,
    i tried the same one but shows an error as Incorrect syntax near 'LIMIT'.