SELECT classBusinessdone FROM a GROUP BY classBusinessdone 得出结果 a1,a2 ,a2 a2, a3,a3 a3 a2, a2 a2 a3,a3
SELECT * FROM a , b where a.orderId =b.orderId and a.classAsertype = 'F'
and a.classBusinessdone in (SELECT classBusinessdone FROM a GROUP BY classBusinessdone ) group by b.projectId order by b.orderCreatedate desc
这种情况下的 in 查询 会自动去重 么? 上面的出的结果 a1,a2 ,a2 a2, a3,a3 a3 a2, a2 a2 a3 实际查询中classBusinessdone并没有 按照上面的区分来分来结果
最后只好 SELECT * FROM a , b where a.orderId =b.orderId and a.classAsertype = 'F' group by b.projectId ,a.classBusinessdone order by b.orderCreatedate desc 这种查询出结果 反而classBusinessdone 字段全部展示出来了
写的sql 比较不规整 意思应该是表达出来了吧?