On Fri, 4 Mar 2011 21:40:36 +0100, Sidney Cadot <sid...@jigsaw.nl> wrote: Hi Sidney, > It is possible by using a nested query, e.g. > > SELECT * FROM (SELECT * FROM some_table ORDER BY timestamp DESC LIMIT 10) > ORDER BY timestamp ASC;
Nice, but it doesn't make sense. It makes everything harder to understand. Reversing the results is a pretty simple thing - but I'm not sure if an SQL engine understands this well enough to result in good performance. Don't try to use SQL for everything, you don't have to. Kind regards Michael -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.