Search results
The ORDER BY command is used to sort the result set in ascending or descending order. The ORDER BY command sorts the result set in ascending order by default. To sort the records in descending order, use the DESC keyword. The ASC command is used to sort the data returned in ascending order.
Learn how to use the SQL ORDER BY clause to sort the result set by one or more criteria in ascending or descending order. See syntax, examples, and tips for using ORDER BY with SELECT statements.
19 lip 2024 · Learn how to use the ORDER BY clause to sort data returned by a query in SQL Server. See the syntax, arguments, best practices, and interoperability of the ORDER BY clause with examples.
9 kwi 2019 · Learn how to use SQL Order by clause to sort results in ascending or descending order in a Select statement. See syntax, usage scenarios and examples with AdventureWorks2017 database.
27 wrz 2022 · Learn how to use the SQL ORDER BY clause to sort query results in ascending or descending order. See examples of ordering by numerical, text, date, or expression columns.
SKŁADNIA ORDER BY. SELECT column1, column2, column3… FROM table_name ORDER BY column1, column2, column3… ASC|DESC; ORDER BY – KIERUNEK SORTOWANIA. Słowo kluczowe ORDER BY dodaje się na końcu zapytania, kiedy wynik jest już zdefiniowany i należy go jedynie uporządkować. Domyślnie sortowanie odbywa się rosnąco (ASCENDING).
Use the ORDER BY clause to sort the result set by columns in ascending or descending order. Use the ASC keyword to sort rows in ascending order. Use the DESC keyword to sort rows in descending order.
