Gossamer Forum
Home : Products : DBMan : Discussions :

Sort by more than one field

Quote Reply
Sort by more than one field
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.
Subject Author Views Date
Thread Sort by more than one field GF2003 2509 Mar 25, 2003, 7:25 AM
Post Re: [GF2003] Sort by more than one field
joematt 2403 Mar 25, 2003, 12:24 PM