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

來源: 於 2004-07-01 13:35:43 [舊帖] [給我悄悄話] 本文已被閱讀：次

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