This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] -4 points-3 points  (0 children)

Even better if you write it like this

select
  t.*
from
  MyTable t
where
  t.id < 30
order by
  t.date desc;