| title | Sort and Group Query Results | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ms.custom | seo-lt-2019 | |||||||||||
| ms.date | 01/19/2017 | |||||||||||
| ms.prod | sql | |||||||||||
| ms.prod_service | sql-tools | |||||||||||
| ms.technology | ssms | |||||||||||
| ms.topic | conceptual | |||||||||||
| helpviewer_keywords |
|
|||||||||||
| ms.assetid | b004e1c0-cacc-4241-9426-9fd426978918 | |||||||||||
| author | markingmyname | |||||||||||
| ms.author | maghan | |||||||||||
| ms.manager | jroth | |||||||||||
| ms.reviewer |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] You can create a query result in which each result row corresponds to an entire group of rows from the original data.
To learn the details about creating such queries, see the topics listed in the following table.
Sort Rows (Visual Database Tools)
Describes the various ways in which you can sort rows and why you would use them.
Collapse Groups of Rows (Visual Database Tools)
Describes the various ways to collapse rows, such as calculating or eliminating duplicates.
Sort with ORDER BY (Visual Database Tools)
Provides steps for returning results in a specified order.
Sort in Ascending or Descending Order (Visual Database Tools)
Provides steps for changing or setting sort direction.
Sort Multiple Columns in Queries (Visual Database Tools)
Provides steps for setting the order of results sets for multiple columns.
Group Rows in Query Results (Visual Database Tools)
Provides steps for creating subsets of summary information by organizing data into groups.
Specify Conditions for Groups (Visual Database Tools)
Provides steps for creating search conditions that apply to groups of rows.
Reorder Output Columns (Visual Database Tools)
Provides steps for changing current sorting settings.
Summarize Query Results (Visual Database Tools)
Provides links to topics on summarizing query results.
Perform Basic Operations with Queries (Visual Database Tools)
Provides links to topics covering the most common query tasks.
Design Queries and Views How-to Topics (Visual Database Tools)
Provides links to topics covering how to use the Query and View Designer.