Question

SQL语句获取MAX()的值后没怎么能获取这个值所对应的主键?

SELECT
USER_ID,
MAX(MEMBER_NUMBER)
FROM
PM_MAN_HOUR_STANDARD

如上SQL,如果直接这么写,得到的MEMBER_NUMBER的最大值列与USER_ID不匹配.怎么能获取最大的MEMBER_NUMBER行的ID呢?

Answer 1

用嵌套查询吧
select user_id from PM_MAN_HOUR_STANDARD where MEMBER_NUMBER =(select MAX(MEMBER_NUMBER)
FROM
PM_MAN_HOUR_STANDARD
)

Answer 2

你查的就是最大值 没有指定要查谁的 要么 where user_id=XX 要么 group by 实在不行 max里边写个子查询也行

Answer 3

SELECT top 1
USER_ID,
MAX(MEMBER_NUMBER) MEMBER_NUMBER
FROM
PM_MAN_HOUR_STANDARD
group by USER_ID
order by MEMBER_NUMBER desc

Answer 4

SELECT
USER_ID,
MAX(MEMBER_NUMBER)
FROM
PM_MAN_HOUR_STANDARD
group by USER_ID

Answer 5

SELECT A.USER_ID FROM PM_MAN_HOUR_STANDARD A WHERE A = (SELELCT MAX(MEMBER)NUMBER FROM PM_MAN_HOUR_STANDARD)