这种更新应该如何操作
id,贴子id,贴子内容,是否第一贴
1,1,'这是第一贴',0
2,1,'bbbbbbbbb',0
3,1,'aaaaaa',0
4,1,'ccccccc',0
5,1,'aaaaaa',0
6,1,'aaaaaa',0
7,1,'dddddddd',0
8,2,'这是第一贴',0
9,2,'bbbbbbbbb',0
10,2,'aaaaaa',0
11,2,'ccccccc',0
12,2,'aaaaaa',0
13,2,'aaaaaa',0
14,2,'dddddddd',0
想给第一个出现的帖子加入第一贴的标记
[解决办法]
表述的不是很清楚啊
[解决办法]
--不是分组后，取第一个吗？
create table t
(
id int,
parentid int,
content varchar(200),
sort int
)
insert into t values (1,1,'123123',0)
insert into t values (2,1,'asdasdasd',0)
insert into t values (3,2,'vrfvfvf',0)
insert into t values (4,2,'43rfrefd',0)
select * from t where id in (select MAX(id) from t group by parentid)
update t set sort=1 where id in (select MAX(id) from t group by parentid)
select * from t
