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

请您先登陆，再发跟帖！