--- 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.