Quote:
Is it possible??Can anyone help me.
It is possible to order by a column and
then by another one (see, for instance
MSDN[
^]). In your scenario it would be
... ORDER BY Lastname ASC, YearOfBirth ASC;
Please note, in your sample data the ordering by 'YearOfBirth' would be irrelevant.