Return the earliest and latest of each product code

[Guest]

I need to find out the earliest entry date and the latest entry date for each
product code. How to do this? Currently I'm doing a primary sort by product
code and secondary sort by date, and then manually picking off the first and
last dates for each product code, but I would like to automate this.

Thanks,
Pat

 

[Jason Lepack]

Assuming the table is structured as such:

Product_Entry:
product_code
entry_date - date/time variable

This will get your result:
SELECT
product_code,
max(entry_date),
min(entry_date)
FROM
Product_Entry
GROUP BY
product_code

Cheers,
Jason Lepack

 

[Guest]

Thanks Jason, works great.

Pat

Assuming the table is structured as such:

Product_Entry:
product_code
entry_date - date/time variable

This will get your result:
SELECT
product_code,
max(entry_date),
min(entry_date)
FROM
Product_Entry
GROUP BY
product_code

Cheers,
Jason Lepack