next up previous
Next: Duplicate Tuples Up: Basic Structure Previous: String Operations

Ordering the Display of Tuples

  1. SQL allows the user to control the order in which tuples are displayed.

     select *

    from loan

    order by amount desc, loan# asc

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

Osmar Zaiane
Fri May 22 19:39:12 PDT 1998