sql search

jda jda at his.com
Wed Apr 19 15:10:02 CDT 2006


Hi Ruslan,

I'd like to have a search that always returns the last 15 records in 
a db. I have an integer field, id, that keeps track of all entries in 
sequential numbers. Here's the kind of thing I'd like:

     select * from tableA where id > (totalrecords- 15)

What would the proper Valentina SQL be for "totalrecords"? (assuming 
this can be done at all).

Thanks,

Jon


More information about the Valentina-beta mailing list