The ORDER BY function is used to sort the records in a query written in MS SQL. Straight or Reverse sorting can be done.

For reverse sorting, DESC must be written at the end of the field or fields to be sorted. For straight sorting, nothing needs to be written, but in some cases ASC is required.

Let's sort the records of our table named PRODUCTS according to the NAME field in reverse.

The query to be written for this should be as follows.

SELECT * FROM PRODUCTS ORDER BY NAME DESC

Bize döndüreceği sonuç aşağıdaki gibi olur.