Date Query

  • Thread starter Thread starter VirginiaR
  • Start date Start date
V

VirginiaR

I have a database that I use to inventory items for a small store. Each item
has a posting date. I want to perform a query that has the earliest posting
date for the items. Help is greatly appreciated.
 
I have a database that I use to inventory items for a small store.  Each item
has a posting date.  I want to perform a query that has the earliest posting
date for the items.  Help is greatly appreciated.
Click to expand...

As a first cut, I'd try this:

SELECT A.*
from Items as A
where A.PostingDate = ( SELECT MIN( PostingDate ) from Items where
ItemID = A.ItemID )
 
Back
Top