sql search

[Ivan Smahin]

Hello Ruslan,

Thursday, April 20, 2006, 8:04:26 AM, you wrote:

> On 4/19/06 10:43 PM, "jda" <jda ÎÁ 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 ?

One more thing you could try

select RecID, * from tableA order by RecID desc LIMIT 15



-- 
Best regards,
 Ivan                            mailto:ivan_smahin ÎÁ valentina-db.com