回複：回複：there is no "last record"

來源: MD/PHD/IT 於 2004-07-01 13:35:43 [] [舊帖] [給我悄悄話] 閱讀數 : (213 bytes)
回答: there is no "last record" 由 f64 於 2004-06-30 19:07:30

Assuming you want the 'Last record' of user_id,here is the statment:

select top 1
max(user_ID),name,address,phone
from table1
group by name,address,phone
order by user_ID desc

Good luck

請您先登陸，再發跟帖！