With Ties Information

With ties looks for values that match the last item in the list and displays them.  It makes  the most sense for rankings. For example, if you wanted to know the top 5 GPAs in a graduating class, you would want to know if other students had the same GPA as the 5th student (they should all have the 5th rank).   It should be noted that SQL uses the column specified in the ORDER BY clause to determine which rows have "tie" values.