if ID Int,
select * from table order by ID desc
没错
if char,
select * from table order by Convert(int,ID) Desc
没错
select * from table order by ID desc
没错
if char,
select * from table order by Convert(int,ID) Desc
没错