Ordering the Display of Tuples

1. SQL allows the user to control the order in which tuples are displayed.
   • order by makes tuples appear in sorted order (ascending order by default).
   • desc specifies descending order.
   • asc specifies ascending order.

    select *
   
   		 from loan
   
   		 order by amount desc, loan# asc
   
   

   Sorting can be costly, and should only be done when needed.