sql search

[jda]

>  >> The first thing comes to my mind is something like this:
>>>
>>>  select * from tableA where id > (select count(*) - 15 from tableA )
>>>
>>>  But it could be expensive query.
>>>
>>>  Probably this task can be redesigned in someway?
>>>  If no - put the feature request to the mantis please.
>>>
>>
>>  Hi Ivan,
>>
>>  This works great. Thanks!
>
>This will work if you not delete records never
>Do you ?
>

Hi Ruslan,

Yes, I do. But when that happens I update the 'id' field so that 
there are no gaps (I don't use RecID). So the sql search above will 
always work with my databases.

Jon