7,714
社区成员
发帖
与我相关
我的任务
分享
select 字段1 ,字段2, (select max(字段1) from 原数据表 where 字段2 is null and 字段1<=a.字段1) as 字段3
from 原数据表 a
SELECT A.字段1,A.字段2,MAX(B.字段1) AS 字段3 FROM TT AS A,
(SELECT 字段1 FROM tt where 字段2 IS NULL)B
WHERE A.字段1>=B.字段1
GROUP BY A.字段1,A.字段2
SELECT A.字段1,A.字段2,MAX(B.字段1) AS 字段3 FROM TT AS A,
(SELECT 字段1 FROM tt where 字段2 IS NULL)B
WHERE A.字段1>=B.字段1
GROUP BY A.字段1,A.字段2