Microsoft Access Database Development With VBA

SQL Keywords: DISTINCT

   

Description

The DISTINCT keyword is used to distinctly select a record. Here is an example:

SELECT DISTINCT Employees.LastName " & _
FROM   Employees " & _
WHERE  LastName = 'Sands';"
 

 

     
 

Home Copyright © 2012 FunctionX, Inc. Home