last 5 records

[mike1955]

Using a large dBase table and want to pull out last 5 entries of a given select type. PK is incremental but records all differ in type. Select statement calling data from varius rows in the table and I just want the last 5 entries.

Tried:

select sample_number from sample
where description = 'WiTower6'
order by sample_number desc
limit 10

but think my syntax is not quite right somehow

any help gratefully appreciated

mike

 

[lewisp]

Very close:

SELECT * FROM (
  select sample_number from sample
  where description = 'WiTower6'
  order by sample_number desc )
WHERE ROWNUM <= 5