order-by-clause-limitations.md

title	ORDER BY Clause 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 SQL grammar, ORDER BY clause limitations ORDER BY clause limitations [ODBC]
ms.assetid	fd4ddc7c-9c7e-4a0c-a781-e5427dfb2e18
author	David-Engel
ms.author	v-daenge

ORDER BY Clause Limitations

If a SELECT statement contains a GROUP BY clause and an ORDER BY clause, the ORDER BY clause can contain only a column in the result set or an expression in the GROUP BY clause.