additional-supported-odbc-sql-grammar.md

description	Additional Supported ODBC SQL Grammar
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-davidengel

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, Correlation Names, and Procedure Invocation topics.

• Approximate numeric literal (Core)

• ALTER TABLE Statement (Core)

• Binary literals (Extended)

• Correlation Names (Core)

• Procedure Invocation (Extended)

• BETWEEN Predicate (Core)

• CREATE INDEX Statement

• Date Arithmetic

• Jet: Date, Time, and Timestamp Literals

• DROP INDEX Statement

• Fixed-Width Text File

• GROUP BY expression-list

• ORDER BY expression-list

• ORDER BY with GROUP BY

• EXISTS predicate (Core)

• IN (valuelist) (Core)

• Jet: Outer Joins (Extended)

• SELECT statement (Extended) (including GROUP BY, HAVING, and UNION clauses)

• Subqueries (SUBSELECTs) (Core)

• Scalar Functions

• Table Names