Noahs Ark

[ciaranmg]

Hi,

I've got a table that lists products and records their category.

I want to write an SQL statement that returns 2 products from each category and lists them by the most recent dates for that category...

If you get my meaning?

Thanks in Advance
C.

[admin]

I suggest a search for the 2 products indexed by a date field...