Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The ORDER BY RANK clause returns the sorted result set of a query based on the rank of scoring functions.
Syntax
ORDER BY RANK <scoring function>
Arguments
| Description | |
|---|---|
scoring function |
Specifies a scoring function like VectorDistance, FullTextScore, or RRF. |
Return types
Returns the sorted result set based on the specified scoring function's rank.
Examples
This section contains examples of how to use this query language construct.
Sort by scoring function rank
In this example, the ORDER BY RANK clause is used to sort results by the rank of a scoring function.
-- Example query for ORDER BY RANK
SELECT * FROM c ORDER BY RANK FullTextScore
[
-- Example result set
]