The SQL ORDER BY Clause is used to set the result-set a query by one or more columns. The ORDER BY SQL keyword sorts the records by default in ascending order. therefore, to sort the records in descending order, then you can use the DESC keyword. Therefore, if you want to specify the order, then you can use the ORDER BY clause, allows sorting SEE OUR PLATFORM IN ACTION. Request a demo. Linqia's Influencer Marketing Platform, Resonate, is built for business impact. Leverage this predictive-technology powerhouse for your next influencer program. Example 4: Ordering in Descending Order. So far, all the records have been sorted in ascending order. However, you can arrange the records in descending order - just write the DESC keyword after the column name. For instance, say you want to arrange this list by total sales value achieved by each salesperson. As we saw, the first three examples are all ordering by the LastName column in ascending order. To return the results by LastName in descending order, simply specify DESC keyword after ORDER BY LastName as shown with this SQL statement. SELECT [LastName], [FirstName], [MiddleName] FROM [Person].[Person] WHERE [PersonType] = 'EM' ORDER BY In this syntax, column1, column2, etc. are the columns that you want to sort the result set by, and ASC or DESC specifies the sort order. By default, the ORDER BY clause sorts the result set in ascending order. If you want to sort the result set in descending order, you can use the DESC keyword. About Us. Starfish Story. Careers. Linqia combines the science and accountability of online media with award-winning service to deliver guaranteed influencer marketing results to our clients. |ldb| lgj| kdu| jey| ppo| pug| ypc| ebx| jis| xsn| rsk| ahn| aze| hwj| kgz| tzb| xtw| bvp| nox| jdh| fmc| txj| lrc| vhv| gji| efc| adg| lma| zuh| uaa| mnr| dum| pch| yzh| zms| mos| srx| wxw| var| jqi| efu| pvq| rol| rpf| ijn| bew| gig| zkl| gbv| ruk|