1,617
社区成员
发帖
与我相关
我的任务
分享
select p1.id,p1.tag_dtm,p1.pl1
from (select id,tag_dtm,row_number()over(partition by trunc(tag_dtm) order by tag_dtm) rn
from jchbsj) p1 where p1.rn =1
select a,b,c
from (select a,b,c,row_number()over(partition by substr(b,1,13) order by b) rn
from 表名称) where rn =1