admin
05-30-2003, 08:07 AM
DISTINCT checks only the fields listed in the SQL string and then eliminates the duplicate rows.
DISTINCTROW checks all the fields in the table and then eliminates the duplicate rows.
So the rule is DISTINCTROW checks all the fields in the table and DISTINCT checks only those fields selected in the SQL string.
DISTINCTROW checks all the fields in the table and then eliminates the duplicate rows.
So the rule is DISTINCTROW checks all the fields in the table and DISTINCT checks only those fields selected in the SQL string.