Skip to content

Instantly share code, notes, and snippets.

@yssymmt

yssymmt/001identifieruniqueness.sql

Created March 16, 2022 16:17
Show Gist options
  • Save yssymmt/b2316461eef988415dff19763e97fe39 to your computer and use it in GitHub Desktop.
Save yssymmt/b2316461eef988415dff19763e97fe39 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
001identifieruniqueness.sql
select
顧客番号,
契約番号,
count(*) as 件数
from データベース名.テーブル名
group by 1,2
having count(*) >1
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment