请问sql过滤参数,想实现多数据集为同一数据集组合查询,union关联后存在重复数据

QQ截图20221202163256.png

FineReport lronlin 发布于 2022-12-2 16:34

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共6回答

最佳回答

Z4u3z1Lv6专家互助
发布于2022-12-2 16:35（编辑于 2022-12-2 17:11）

你这不ID 不一样啊

-------

SELECT id, NAME AS '姓名', education AS '学历', whether_ex_serviceman AS '是否退役军人', certificate_holding AS '持证情况', registered_residence AS '所在地区' FROM lhyg_talent_data WHERE (education = '博士') OR (whether_ex_serviceman = '') OR (certificate_holding IS NOT NULL AND certificate_holding = '')

举报收起评论(4)

lronlin(提问者) ID不一样的, 用于后面传参

2022-12-02 16:39

Z4u3z1 回复 lronlin(提问者) 你这个都是查的同一张表啊，赵莹在表中有两个ID啊。另外你的SQL貌似可以改一下。复制SQL出来吧，这么长打字麻烦

2022-12-02 16:44

lronlin(提问者) 回复 Z4u3z1 SELECT id, NAME AS \'姓名\', education AS \'学历\', whether_ex_serviceman AS \'是否退役军人\', certificate_holding AS \'持证情况\', registered_residence AS \'所在地区\' FROM lhyg_talent_data WHERE education = \'博士\' UNION SELECT id, NAME AS \'姓名\', education AS \'学历\', whether_ex_serviceman AS \'是否退役军人\', certificate_holding AS \'持证情况\', registered_residence AS \'所在地区\' FROM lhyg_talent_data WHERE whether_ex_serviceman = \'\' id UNION SELECT id, NAME AS \'姓名\', education AS \'学历\', whether_ex_serviceman AS \'是否退役军人\', certificate_holding AS \'持证情况\', registered_residence AS \'所在地区\' FROM lhyg_talent_data WHERE certificate_holding IS NOT NULL AND certificate_holding = \'\'

2022-12-02 17:06