sql search

[Ruslan Zasukhin]

On 4/19/06 10:43 PM, "jda" <jda at his.com> wrote:

>> 
>> 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 ?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]