S stuwe Unregistered / Unconfirmed GUEST, unregistred user! 2003-07-05 #22 SELECT rowno = (SELECT COUNT(*) FROM table a WHERE a.autoid < b.autoid) + 1, * FROM table b ORDER BY autoid 這樣可以實現,數據多時可能效率不好
SELECT rowno = (SELECT COUNT(*) FROM table a WHERE a.autoid < b.autoid) + 1, * FROM table b ORDER BY autoid 這樣可以實現,數據多時可能效率不好
Z zealothasu Unregistered / Unconfirmed GUEST, unregistred user! 2003-07-05 #23 还是不行啊 你想要是不包含正形的字段怎么办?
S stuwe Unregistered / Unconfirmed GUEST, unregistred user! 2003-07-05 #24 如果不包含有某一個可比較或排序的字段 那你要這個編號也沒什麼意義
S stuwe Unregistered / Unconfirmed GUEST, unregistred user! 2003-07-05 #25 如果要得到行號也可以用計算字段去實現,那樣更方便一點