problem getting n last items

[abelgv]

hi,

i'm working with sql server 7 and i have a table like this:

---------------------
id date section

1 1/1/2001 2
2 2/2/2002 3
etcetera
---------------------

I need to get the 5 last items from every section, "last items" means order by date desc... I cannot find the sql expression... "5 last items from every section" means
that the sql should return 15 rows if i have 3 sections,
supossing there are 5 items available for every section.

Thanks for any help.
Abel
---------------------------

http://www.infolibo.com/bci

 

[bperry]

Try this: (untested)

select *
from YourTable u1
where Date in (select TOP 3 Date from YourTable u2
where u2.Section=u1.Section
order by Date desc)
Order by Section, date desc

 

[abelgv]

thank you very much it works great ---------------------------

http://www.infolibo.com/bci