[Special Characters][A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]
On is used in the join clauses. See the example below which returns a list of lists showing various types of items inside a database.
Order-by does what it says on the label:
If you want to change the default from ascending to descending, then the relevant column name is enclosed in a :desc term like so:
Note that :order-by has one or more parameters [Just one in this example] and :limit has 2 possible parameters, the limit and the offset. Note that the :order-by and :limit forms are wrapped around the :select form. The only difference between the two queries is the offset parameter.
Over is available in postmodern as of the Oct 29 git updates. See also the examples for partition-by
Consider briefly at what "over" generates"
So, if you wanted an sql statement such as:
The postmodern version would be:
Postmodern examples >