---
title: "Additional Supported ODBC SQL Grammar | 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: 
  - "SQL grammar [ODBC]"
  - "ODBC drivers [ODBC], SQL grammar"
ms.assetid: 2ead7727-3245-4c2b-91f5-ed946ef4edf5
author: David-Engel
ms.author: v-daenge
---
# Additional Supported ODBC SQL Grammar
The ODBC drivers completely support the Minimum ODBC 2.5 grammar and the following clauses in the Core and Extended ODBC 2.5 grammar. Additional information can be displayed by jumping to the [ALTER TABLE Statement](../../odbc/microsoft/alter-table-statement.md), [Correlation Names](../../odbc/microsoft/correlation-names.md), and [Procedure Invocation](../../odbc/microsoft/procedure-invocation.md) topics.  
  
-   Approximate numeric literal (Core)  
  
-   [ALTER TABLE Statement](../../odbc/microsoft/alter-table-statement.md) (Core)  
  
-   Binary literals (Extended)  
  
-   [Correlation Names](../../odbc/microsoft/correlation-names.md) (Core)  
  
-   [Procedure Invocation](../../odbc/microsoft/procedure-invocation.md) (Extended)  
  
-   [BETWEEN Predicate](../../odbc/microsoft/between-predicate.md) (Core)  
  
-   [CREATE INDEX Statement](../../odbc/microsoft/create-index-statement.md)  
  
-   [Date Arithmetic](../../odbc/microsoft/date-arithmetic.md)  
  
-   [Jet: Date, Time, and Timestamp Literals](../../odbc/microsoft/jet-date-time-and-timestamp-literals.md)  
  
-   [DROP INDEX Statement](../../odbc/microsoft/drop-index-statement.md)  
  
-   [Fixed-Width Text File](../../odbc/microsoft/fixed-width-text-file.md)  
  
-   [GROUP BY expression-list](../../odbc/microsoft/group-by-expression-list.md)  
  
-   [ORDER BY expression-list](../../odbc/microsoft/order-by-expression-list.md)  
  
-   [ORDER BY with GROUP BY](../../odbc/microsoft/order-by-with-group-by.md)  
  
-   EXISTS predicate (Core)  
  
-   IN (*valuelist*) (Core)  
  
-   [Jet: Outer Joins](../../odbc/microsoft/jet-outer-joins.md) (Extended)  
  
-   SELECT statement (Extended) (including GROUP BY, HAVING, and UNION clauses)  
  
-   Subqueries (SUBSELECTs) (Core)  
  
-   [Scalar Functions](../../odbc/microsoft/scalar-functions.md)  
  
-   [Table Names](../../odbc/microsoft/table-names.md)