BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

103SELECT expressions without a table
104FROM and table references
105Selecting named columns
106SELECT * and schema coupling
107Column aliases with AS
108Table aliases
109Qualified column names
110SQL comments and statement terminators
111Quoted identifiers and case folding
112String literals and escaped quotes
113Numeric literals
114Boolean literals
115Logical query processing order
116Query output types
117Reading product names from a bookstore catalog
118Computing line totals from order items
119WHERE row filtering
120Equality with =
121Inequality with <> and !=
122Less-than and greater-than comparisons
123Inclusive comparisons with <= and >=
124Boolean AND
125Boolean OR
126Boolean NOT
127Operator precedence in predicates
128Parentheses in compound predicates
129BETWEEN and inclusive endpoints
130NOT BETWEEN
131IN with literal lists
132NOT IN with literal lists
133LIKE wildcard matching
134LIKE escape characters
135ILIKE case-insensitive matching
136SIMILAR TO patterns
137POSIX regex matching with ~
138Case-insensitive regex matching with ~*
139Regex negation with !~ and !~*
140IS TRUE and IS FALSE
141IS NOT TRUE and IS NOT FALSE
142IS UNKNOWN and IS NOT UNKNOWN
143ORDER BY ascending and descending
144Sorting by multiple keys
145ORDER BY expressions
146ORDER BY output aliases
147NULLS FIRST and NULLS LAST
148Stable ordering with unique tie-breakers
149LIMIT row counts
150OFFSET row skipping
151FETCH FIRST rows only
152FETCH WITH TIES
153DISTINCT across selected columns
154PostgreSQL DISTINCT ON
155DISTINCT ON ordering requirements
156Collations and alphabetical sorting
157ORDER BY USING operators
158Keyset pagination for bookstore titles
159Finding the newest sensor readings
160Selecting the cheapest product in each category
161Filtering delayed shipments with nested predicates
162Paginating a library catalog without skipped rows

Databases & SQL

103SELECT expressions without a table
104FROM and table references
105Selecting named columns
106SELECT * and schema coupling
107Column aliases with AS
108Table aliases
109Qualified column names
110SQL comments and statement terminators
111Quoted identifiers and case folding
112String literals and escaped quotes
113Numeric literals
114Boolean literals
115Logical query processing order
116Query output types
117Reading product names from a bookstore catalog
118Computing line totals from order items
119WHERE row filtering
120Equality with =
121Inequality with <> and !=
122Less-than and greater-than comparisons
123Inclusive comparisons with <= and >=
124Boolean AND
125Boolean OR
126Boolean NOT
127Operator precedence in predicates
128Parentheses in compound predicates
129BETWEEN and inclusive endpoints
130NOT BETWEEN
131IN with literal lists
132NOT IN with literal lists
133LIKE wildcard matching
134LIKE escape characters
135ILIKE case-insensitive matching
136SIMILAR TO patterns
137POSIX regex matching with ~
138Case-insensitive regex matching with ~*
139Regex negation with !~ and !~*
140IS TRUE and IS FALSE
141IS NOT TRUE and IS NOT FALSE
142IS UNKNOWN and IS NOT UNKNOWN
143ORDER BY ascending and descending
144Sorting by multiple keys
145ORDER BY expressions
146ORDER BY output aliases
147NULLS FIRST and NULLS LAST
148Stable ordering with unique tie-breakers
149LIMIT row counts
150OFFSET row skipping
151FETCH FIRST rows only
152FETCH WITH TIES
153DISTINCT across selected columns
154PostgreSQL DISTINCT ON
155DISTINCT ON ordering requirements
156Collations and alphabetical sorting
157ORDER BY USING operators
158Keyset pagination for bookstore titles
159Finding the newest sensor readings
160Selecting the cheapest product in each category
161Filtering delayed shipments with nested predicates
162Paginating a library catalog without skipped rows

← Databases & SQL

Search the Databases & SQL glossary

Lesson 149 of 2,478·3. SELECT and Relational FilteringFree lesson

LIMIT row counts

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy