mssql group by having 運用

mssql group by having 運用
select bk_bar from book group by bk_bar having count(bk_bar )>1
/*相同條碼>1*/