Re: Reordering Rows

[Paul DuBois]

At 18:37 -0600 4/29/03, Keith Spiller wrote:
>Hello,
>
>I am trying to figure out how to reorder the rows in a table.
>This would be the simplest way I can image to control a sort order,
>if I could move a row up, down or to the beginning or end of the table.

The proper way to do this is to order them when you retrieve them
by adding an ORDER BY clause to your SELECT query.

>
>Is there anyway to accomplish this?  Can you provide any links or
>resources on reordering rows?
>
>Thanks,
>
>Keith