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
select top 1
max(user_ID),name,address,phone
from table1
group by name,address,phone
order by user_ID desc
Good luck
選擇“Disable on www.wenxuecity.com”
選擇“don't run on pages on this domain”
