TAdoQuery中如何写降序查询

[golinjin]

按年龄从大到小查询students
AdoQuery1.SQL.Add('select * from students order by age....');后面呢？

[Spqk005]

asc
dec是降序

[Spqk005]

select * from students order by age desc

[golinjin]

提示语法错误啊
语法错误。在查询表达式‘age select * from students’中。

[dickeybird888]

AdoQuery1.SQL.Add('select * from students order by age desc');

[cnhgj]

desc

[golinjin]

如果年龄相同的则根据姓名升序排列又该怎么做?

[Spqk005]

select * from students order by age desc,name Asc

[checkyvc6]

select * from students order by age desc,name Asc.....