可能我没有表达清楚意思,查询的时候,70不是固定的,比如还有71分相同的,72分相同的等等。 我现在可以用以下语句查出相同分数的记录 select * from xusheng where forms in (select forms from xuesheng group by froms having count(*)>1)但是如何给最后相同分数的最后一条记录上标记?
try: update a set a.ts = '标记' from 表 a where a.id = (Select max(id) from 表 where a.froms = froms group by froms having count(*) > 1)
我现在可以用以下语句查出相同分数的记录
select * from xusheng where forms in (select forms from xuesheng group by froms having count(*)>1)但是如何给最后相同分数的最后一条记录上标记?
update a
set a.ts = '标记'
from 表 a
where a.id = (Select max(id) from 表 where a.froms = froms group by froms having count(*) > 1)
语句已终止。