Hi everyone,
Is one of these more correct than the other ?
1) select distinct customer_number, address_code from orders;
2) select customer_number, address_code
from orders
group by customer_number,address_code;
Our developers do the 1st one mostly. It always bothers me, I'm not sure why, I guess I just think of it as looking ambiguous even though it does return the same result as the second option.
Any opinions? Does it matter at all?
TIA,
Beth
