Steffen Lindauer wrote: > i'm searching for a solution, getting the last 10 records of a > database. I've got a table with timestamps and corresponding values. > > SELECT ts,value FROM table WHERE rowno <= COUNT(*)-10''; doesn't work, > can sb help me plz?
You could use select ts,value from table order by ts desc and fetch only the first n rows. Regards, Holger -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
