How do you determine the order in which the rows in a

How do you determine the order in which the rows in a response to an SQL query appear? What options do you have when specifying this order?