Home > Articles > Data

  • Print
  • + Share This

The ORDER BY Clause

The ORDER BY clause sorts the returned Recordset in ascending or descending order according to one or more of the properties specified. The basic syntax is

ORDER BY "<property name>" [, "<some more property names>"] 
    [ASC or DESC]

For example,

SELECT "DAV:href", "urn:schemas:contacts:fileas", _
   "urn:schemas:contacts:email1", _
   "urn:schemas:contacts:st"
FROM "file://./backofficestorage/GomezaMobile.local/MBX/Administrator/
             Contacts"
ORDER BY "urn:schemas:contacts:st" ASC
  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.