PostgreSQL Select Query 59 codes

  1. Home
  2. PostgreSQL
  3. Select Query
1 A simple WHERE clause
2 A verbose explanation of a simpler query, with the VERBOSE keyword
3 Aggregate function, group by and having
4 Case when statement
5 Cast row function
6 Combining comparisons with Boolean operators
7 Combining conditions in the WHERE clause
8 Comparing strings
9 Comparing two rows
10 Comparison operators with AND
11 Comparisons equal to NULL
12 Comparisons using IS NULL
13 Correct operator usage
14 DISTINCT ON
15 Duplicate rows be removed from the result of a query
16 Executing EXPLAIN for a query
17 Group by and having
18 Grouping WHERE conditions with parentheses
19 Insert string with quotation
20 Is a shorthand for all columns
21 Like with single wild card char
22 Like with wild card char
23 NATURAL JOIN works with LIMIT and OFFSET
24 NOT for boolean value
25 Observing NULL values
26 Operator equivalents to BETWEEN
27 Operator Precedence Demo
28 Order by in ascending order
29 Pass row function to function
30 Row Constructors
31 Select constant value
32 SELECT text a AS text UNION SELECT b
33 Specify the table columns in a select statement
34 Specifying Target Columns
35 Type Resolution in a Transposed Union
36 Use subquery in where statement
37 Using AND in where clause
38 Using BETWEEN
39 Using case expressions in statements
40 Using comparison operators
41 Using DISTINCT
42 Using DISTINCT and ORDER BY together
43 Using DISTINCT with ORDER BY
44 Using EXCEPT for two data sets
45 Using expressions
46 Using expressions and constants
47 Using function in subquery in where statement
48 Using INTERSECT for two data sets
49 Using LIMIT for Natural Join
50 Using Mathematical Operators
51 Using operators with NULL values
52 Using OR in where clause
53 Using ORDER BY
54 Using ORDER BY with multiple expressions
55 Using Row function in a function
56 Using SELECT INTO
57 Using the HAVING clause with inner join
58 Using UNION for two data sets
59 WHERE clause contains a Boolean (truth value) expression