DISTINCT is used in the SELECT statement to return unique values in a field. DISTINCT checks only the selected fields listed in the SQL string and then eliminates the duplicate rows. If the SELECT clause contains more than one field, the combination of values from all fields must be unique for a given record to be included in the results. The output of a query that uses DISTINCT is not updatable. DISTINCTROW checks for all fields in the table that is being queried and eliminates duplicates based on the entire record not just the selected fields. The query results from DISTINCTROW can be updated because the fields correspond to the individual records in the table.
To download example Access file please click on the link below
[ Ссылка ]
