This article provides an example to display item details in descending order of item price using order by clause in select query.
select * from item orderby itemprice desc;