Do's and Don'ts of the SQL SELECT statement
SQL SELECT Statement cheat sheet
Estimated reading time: 1 minutes.

There’s one thing no application can live without – the database. Most databases speak SQL, and so we’ve dedicated this cheat sheet to the important topic of SQL SELECT statements.

REGEX PATTERNS

Pattern What the pattern matches
^ Beginning of string
$ End of string
. Any single character
[…] Any character listed between the square brackets
[^…] Any character not listed between the square brackets
p1|p2|p3 Alternation; matches any of the patterns p1, p2, or p3
* Zero or more instances of preceding element
+ One or more instances of preceding element
{n} n instances of preceding element
{m,n} m through n instances of preceding element
Next Generation SQL Data Analysis Write SQL, visualize data, and share your results. Onboarding forward-thinking teams now:

No spam, ever! Unsubscribe any time. Learn more about the product.