␡
- The ADO/OLE DB Conspiracy
- What Does ADO 2.5 Have to Do with Exchange 2000?
- The Role of the Web Storage System
- The Exchange OLE DB Provider
- File URLs
- HTTP URLs
- Programmatically Getting a User's HTTP Mailbox Folder URLs
- The Open Method of the ADO 2.5 Record Object
- Using Web Storage System SQL to Get a List of Folders
- Web Storage System SQL
- The SELECT Statement
- The ORDER BY Clause
- The RANK BY Clause
- Some Unsupported SQL
- Summary
The RANK BY Clause
Finally, there is the RANK BY clause. Ranking can be used to sort results on the basis of how frequently and where the queried strings appear in the indexed documents. In a nutshell, this is how Internet tools such as a search engine know how to sort the results. The basic syntax is
RANK BY <clause>(Mechanism, weight)
The value of the clause can be either WEIGHT or COERSION. The Mechanism refers to an action such as WEIGHT, MULTIPLY, or ABSOLUTE. The weight is the significance of the rank. See the Microsoft Exchange 2000 SDK for more information.