sql="select top 5 * from Teacher where kc_qyxs=1 and te_wjlb_b=2 order by kc_pqh asc"

他会显示所有的记录,而不是前5行

sql="select top 5 * from Teacher where kc_qyxs=1 and te_wjlb_b=2 order by kc_pqh desc"

这行才显示前5个记录,真晕,靠

[此贴子已经被作者于2006-12-1 9:51:01编辑过]

kc_pqh
数字,

sql="select top 10 * from Teacher where kc_qyxs=1 and te_wjlb_b=2 order by kc_pqh desc"


这样时,他就会显示11行

如果by id desc 就没错了,这是什么原因,难倒还非得自己编号的才行?

[此贴子已经被作者于2006-12-1 11:33:48编辑过]