回复：回复：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