Learn how to query and transform data in Pixeltable using where() and select()
where()
select()
order_by()
limit()
collect()
, making them efficient for complex operations. You can build queries incrementally, adding conditions and transformations as needed.
movies
table from Tableswhere()
to filter rows based on basic conditions:title | year | budget |
---|---|---|
Titanic | 1997 | 200.0 |
Avengers: Endgame | 2019 | 356.0 |
Text Filtering
Multiple Conditions
&
(and), |
(or):Sorting Results
order_by()
to sort results:movies.title
).where()
, select()
, order_by()
, and limit()
in any order.&
(and), |
(or), and ~
(not) for complex conditions.