RE: Help for a quite simple quesry?

2001-03-13 Thread Cal Evans
Select * from table order by age, name, surname Select * from table order by age, name, surname where age>11 Cal http://www.calevans.com -Original Message- From: Rino Nucara [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 5:18 AM To: MySQL mailing list Subject: Help fo

Help for a quite simple quesry?

2001-03-13 Thread Rino Nucara
I have tree columns: name,surname,age. how can I order this columns first by age, then by name , at the and by surname. like that: NAMESURNAME AGE zanna bond10 barbara astic 15 barbara bard40 barbara zard