本文提供了一个SQL查询示例，展示了如何从cop_customer_project_mvt表中筛选特定客户ID为566110且FSTEP_CODE包含指定阶段的记录，并按FSTART_DATE降序排列。
SELECT *
FROM cop_customer_project_mv t
WHERE t.fcust_party_id = 566110
AND '1,2,3,4,5' like '%' ||t.FSTEP_CODE || '%'
ORDER BY t.fstart_date DESC
FROM cop_customer_project_mv t
WHERE t.fcust_party_id = 566110
AND '1,2,3,4,5' like '%' ||t.FSTEP_CODE || '%'
ORDER BY t.fstart_date DESC
扫一扫
485
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
