rank

relationalai.semantics.std.aggregates

rank(*args: AggValue | Ordering) -> Aggregate

Compute rank based on the ordering of values.

Parameters

• *args

  (AggValue | Ordering, default: ()) - Values or Ordering specifications to rank by.

Returns

• Aggregate - An Aggregate representing the computation of the rank. Returns Integer.

Examples

Rank employees by salary:

select(Employee, aggregates.rank(aggregates.desc(Employee.salary)))

Rank products by price per category:

select(
    Product,
    aggregates.rank(aggregates.asc(Product.price))
    .per(Category)
    .where(Product.category == Category),
)

Referenced By

RelationalAI Documentation
└──  Build With RelationalAI
    └──  Understand how PyRel works
        ├──  Build a semantic model
        │   └──  Query a model
        │       └──  Rank and select top results with rank, asc, desc, and top
        └──  Use advanced reasoning > Rules-based reasoning
            └──  Aggregate and group data
                └──  Rank groups with .rank()