在运行时在sql数据库中过滤掉重复的值 - 基于集合

I have a database issue that i currently cannot wrap my head around with an easy solution. In my db I have a table that stores event values.. 0's and 1's with a timestamp. Issue being that it is possible for there to be the same event to occur twice as a business rule. Like belowI have a database issue that i currently cannot