Subject | whats the opposite of first? |
---|---|
Author | martinknappe |
Post date | 2006-10-17T21:24:38Z |
hi,
when i want to select the first 5 entries from a table i do something
like:
select first 5 field from table order by field ascending
now, what do i do if i want to select the LAST 5 ? (but keeping the
same order)
select last 5 field from table order by field ascending
doesnt work (fb 1.5)
thanx
martin
when i want to select the first 5 entries from a table i do something
like:
select first 5 field from table order by field ascending
now, what do i do if i want to select the LAST 5 ? (but keeping the
same order)
select last 5 field from table order by field ascending
doesnt work (fb 1.5)
thanx
martin