2019-11-21から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
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