Hi,
i know that it is possible to sort by any field and also to ascend or descend the output-order. but is it also possible to sort by more than one field?
if so, how to do this - and if [b]not[/b]: what is the sorting-order if there is more than one field with same content. is it sorted by the ID, or ...?
e.g.
ID | Name | Age
1 | John| 19
2 | Linda | 23
3 | Alex | 19
and, now if i sort by Age and descending, what is the output, and why? is it
a) Linda -> John -> Alex, or
b) Linda -> Alex -> John
looking forward to your replies. thanx. Gerhard.
i know that it is possible to sort by any field and also to ascend or descend the output-order. but is it also possible to sort by more than one field?
if so, how to do this - and if [b]not[/b]: what is the sorting-order if there is more than one field with same content. is it sorted by the ID, or ...?
e.g.
ID | Name | Age
1 | John| 19
2 | Linda | 23
3 | Alex | 19
and, now if i sort by Age and descending, what is the output, and why? is it
a) Linda -> John -> Alex, or
b) Linda -> Alex -> John
looking forward to your replies. thanx. Gerhard.