EASY if you have half a brain (SQL Order By - 2 different values)

[johnsmith153]

How would I set two different values using "Order By" in SQL (ie so it sorts into order of a person's age, and then for duplicates it orders by their name)

 

"Order By age,name" wont work either.

[premiso]

ORDER BY age, name

 

Should work, show us the query.

[Mchl]

It should. That's the correct syntax.

[PFMaBiSmAd]

Post an example of your data, your table definition, and the results you are getting. I'm going to guess that your age calculation is incorrect or it is not a numeric data type.

 

Telling us something does not work is pointless, we know it is not or you would not be posting in a help forum, you need to show exactly what it is or is not doing.