How to use $orderby in OData?

 In OData, the $orderby query option is used to specify the order in which entities should be returned in a query response based on the values of one or more properties.

The basic syntax for using $orderby is as follows:

sql
http://serviceRootURL/EntitySet?$orderby=Property [asc|desc][, Property [asc|desc],...]

where serviceRootURL is the base URL of the OData service, EntitySet is the name of the entity set you want to query, Property is the name of the property you want to sort by, and asc or desc is used to specify whether the sorting should be in ascending or descending order.

For example, let's say you have an OData service that exposes a collection of Products, each of which has ProductId, Name, Price, and Category properties. If you want to retrieve all the products in the collection sorted by price in descending order, you can use the following query:

bash
http://serviceRootURL/Products?$orderby=Price desc

This will return a response that includes all the products in the collection sorted by price in descending order.

Note that you can also sort by multiple properties by separating the property names with commas. For example, if you want to sort the products by category first, and then by price within each category in descending order, you can use the following query:

bash
http://serviceRootURL/Products?$orderby=Category,Price desc

This will return a response that includes all the products in the collection sorted by category first, and then by price within each category in descending order.