2005/9/7, Jens-Peter C. Hillers <[EMAIL PROTECTED]>: > Hello, > > ill try to get the last ten rows without fetching the whole table (ODBC !)
> any help`? Maybe you can use ROWNUM / ROWID. You might need a nested query # untested select * from ( select .... ) where rowid >= MAX(rowid) - 10 Cheers robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]