--- title: "Set Functions Limitations | Microsoft Docs" ms.custom: "" ms.date: "01/19/2017" ms.prod: sql ms.prod_service: connectivity ms.reviewer: "" ms.technology: connectivity ms.topic: conceptual helpviewer_keywords: - "ODBC desktop database drivers [ODBC]" - "desktop database drivers [ODBC]" ms.assetid: 18e7a0fd-cc5d-4109-b542-cac6893a29c3 author: David-Engel ms.author: v-daenge --- # Set Functions Limitations The set functions (AVG, MAX, MIN, and SUM) do not support the DISTINCT keyword.