想把字段为空的纪录放在最前面

[shdcsdn]

no name age
1001 aaa 10
2002 20
3000 33
4000 ddd 4

经过select后，想变成。
no name age
2002 20
3000 33
1001 aaa 10
4000 ddd 4

如何select，谢谢了！

[vokeyliu]

按照name的降序排列啊
select * from aaa order by name desc

[yyy21]

select * from table order by name nulls first

[preciouszhao]

select no,name,age from table order by 2;

[preciouszhao]

select no,name,age from table order by 2 DESC;