例如如下sql,
SELECT * FROM(
SELECT u.*,ROW_NUMBER()OVER(PARTITION BY p.user_id ORDER BY p.flush_time desc)RN
FROM STS_LPATROL_APPUSER_T u
left JOIN STS_LPATROL_PHONEDEV_T p ON u.user_id=p.user_id)T where RN=1
利用 ROW_NUMBER()OVER 函数进行分类(PARTITION BY)排序(ORDER BY ),取出多方的最新一条数据进行展示。