Home » Solar Hacks Corner » Which Clause Is Used for Sorting Rows in Sql?

Which Clause Is Used for Sorting Rows in Sql?

Alexander Ross • • 6 min read
Which Clause Is Used for Sorting Rows in Sql?

The SQL ORDER BY Keyword
The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default.

Which is used to sort rows in SQL?

The ORDER BY statement in SQL is used to sort the fetched data in either ascending or descending according to one or more columns. By default ORDER BY sorts the data in ascending order. We can use the keyword DESC to sort the data in descending order and the keyword ASC to sort in ascending order.

Which clause is used to arrange rows?

The WHERE clause is used to constrain which rows to retrieve. We do this by specifying a boolean predicate that compares the values of table columns to literal values or to other columns. The ORDER BY clause gives us a way to order the display of the rows in the result of the statement.

Alexander Ross
Author

Alexander Ross

Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.