So how do you "know" when you can safely omit DISTINCT for your shiny new query SELECT x FROM t ? Oh you looked the schema for t and it said x has a PRIMARY or UNIQUE constraint? Ah well two minutes after you looked at…
So how do you "know" when you can safely omit DISTINCT for your shiny new query SELECT x FROM t ? Oh you looked the schema for t and it said x has a PRIMARY or UNIQUE constraint? Ah well two minutes after you looked at…