关于读数据库顺序的问题

[test77885]

sql="select * from lst where username='"&username&"'"
读出所有username字段内符合条件的数据..
我的问题是要从表底部往上读,意思就是最新添加的记录显示在最前面
不知如何操作,望指点!

[fangq]

sql="select * from lst where username='"&username&"' order by id desc"

[rebacca1620]

sql="select * from lst where username='"&username&"' order by id desc"
id是表的主键

[fangq]

或
sql="select * from lst where username='"&username&"' order by id asc"

[kafly]

sql="select * from lst where username='"&username&"' ORDER BY [id] DESC"

[clare2003]

sql="select * from lst where username='"&username&"' order by UserName desc"

[test77885]

非常感谢,问题解决!