[AccessD] Select question

SELECT DISTINCT returns a unique recordset based on the field that follows
the DISTINCT keyword. SELECT DISTINCTROW returns a unique recordset based on
all the fields in the retrieved recordset. 

Susan H. 

What is the difference between select distinct and select distinctrow. When
would I use one instead of the other. I have looked and cannot find the
answer Thanks John