データのunique, primaryキー確認方法
table : oubo_summary column dt, oubo_shubetsu_mei, aa,bbb, ccc
uniqueキーはdtとoubo_shubetsu_meiだとした時に確認方法
select dt, oubo_shubetsu_mei, count(*) as count from oubo_summary group by dt, oubo_shubetsu_mei having count > 1
table : oubo_summary column dt, oubo_shubetsu_mei, aa,bbb, ccc
uniqueキーはdtとoubo_shubetsu_meiだとした時に確認方法
select dt, oubo_shubetsu_mei, count(*) as count from oubo_summary group by dt, oubo_shubetsu_mei having count > 1