Microsoft Access Database Development With VBA

SQL Keywords: DISTINCTROW

   

Description

If you are creating a SELECT statement that involves a relationship, use the DISTINCTROW operator to get distinct records. Here is an example:

SELECT DISTINCTROW Videos.CopyrightYear,
		   Sum(Videos.PriceBought) AS [Sum Of PriceBought],
		   Count(*) AS [Count Of Videos]
FROM Videos
GROUP BY Videos.CopyrightYear
HAVING (((Videos.CopyrightYear) Is Not Null));
 
     
 

Home Copyright © 2012-2013 FunctionX, Inc. Home