回複：there is no "last record"

來源: tryyyyyy 於 2004-06-30 21:55:46 [] [舊帖] [給我悄悄話] 閱讀數 : (82 bytes)
回答: 回複：SQL statement about going t 由 lidongmei 於 2004-06-30 18:46:10

select top 1
user_ID,name,address,phone
from table1
order by user_ID desc

所有跟帖： 

• This is for SQL Server, not -smartll- ♀ 給 smartll 發送悄悄話 (60 bytes) () 07/01/2004 postreply 01:02:23

• It work in Access -tryyyyyy- ♀ 給 tryyyyyy 發送悄悄話 (0 bytes) () 07/01/2004 postreply 07:01:29

• 回複：回複：there is no "last record" -MD/PHD/IT- ♀ 給 MD/PHD/IT 發送悄悄話 (213 bytes) () 07/01/2004 postreply 13:35:43

請您先登陸，再發跟帖！