Women in Technology

Hear us Roar



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')

Full Threads Oldest First

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 [View]

    Obviously you'd need count() too :).