sql server函数partition by的用法

1，partition by的用法

SELECT * FROM (

SELECT user_id , login_time ,row_number() over (partition by user_id order by login_time desc) MM from xxx)

WHERE mm = 1