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]

Reply via email to