DISTINCT : DISTINCT checks
only the fields listed in the SQL string and then eliminates the duplicate
rows. Results of DISTINCT queries are not updateable. They are a snapshot of
the data.
DISTINCT
queries are similar to Summary or Totals queries (queries using a GROUP BY
clause).
DISTINCTROW: DISTINCTROW, on
the other hand, checks all fields in the table that is being queried, and
eliminates duplicates based on the entire record (not just the selected
fields). Results of DISTINCTROW queries are updateable.
0 comments:
Post a Comment