Thank you all for your hints!!! The easiest way, of course, is to use *orderby *and *limitby*. It works fine. But the MAX method is usefull too. I'll use it in my projects.
On Wednesday, September 12, 2012 5:09:07 PM UTC+4, Vladimir Makarov wrote: > > So, I need to select data from the table but the only ten last rows (with > highest id). > I have already tried with select all records and then use while statement > but I think there is another way. > Any ideas? Thanks! > --