How to implement conditional COUNTIF in SQL?

Question

I am new to SQL and facing the problem for the while. The question is how to create such Label column in SQL?

Goal: When group count is more than 1 it should be 'Y' otherwise 'N'

Here is what I do in Excel (please see screenshot).

Screenshot

Gordon Linoff · Accepted Answer · 2020-10-27 10:51:46Z

1

I think you want case with a window function:

select (case when count(*) over (partition by item) > 1 then 'Y' else 'N' end) as label

answered Oct 27, 2020 at 10:51

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you! It works on test env, now I am going to try it on real data and will return to you!