postgresql 去除
·
select * from(
select row_number() over(partition by from_id,createtime order by nickname) as flag,* from(
SELECT
from_id,max(createtime) as createtime,isread as nickname
FROM
comments
WHERE
ctype=2015
AND to_id=2554
AND foreign_id=1
group by from_id,isread
order by from_id
)as tb1
)as tb2
where flag = 1
select row_number() over(partition by from_id,createtime order by nickname) as flag,* from(
SELECT
from_id,max(createtime) as createtime,isread as nickname
FROM
comments
WHERE
ctype=2015
AND to_id=2554
AND foreign_id=1
group by from_id,isread
order by from_id
)as tb1
)as tb2
where flag = 1
北京人形旗下天工造物具身智能开源社区，聚焦具身天工与慧思开物两大平台
更多推荐
0
0- 0
已为社区贡献3条内容
所有评论(0)