Lesson 06 · 11 min
Filters, pagination, and aggregates
AND, OR, case-insensitive search, cursors, and counts without loading rows.
11 minLesson 6 of 9Practice includedAsk AI on any point
Conditions in where combine with AND (all fields of the object by default), OR, and NOT. For text there's contains, startsWith, and mode: "insensitive" in PostgreSQL. Pages use skip/take or a cursor: cursor + skip: 1 + take. count, aggregate, and groupBy compute on the database side and return numbers, not thousands of rows.
Sign in to continue
The rest of this lesson opens after sign up
The first lesson of every course is open without an account. To read on, solve the practice and use Ask, create a free account or log in.