Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Change to requirement marks in lang.in. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
b5882b3f8fbebb225c53d0625b66f293 |
| User & Date: | dan 2010-09-11 17:46:27 |
Context
|
2010-09-13
| ||
| 12:06 | Added documentation on the SQLITE_4_BYTE_ALIGNED_MALLOC compile-time option. (check-in: dc93bef322 user: drh tags: trunk) | |
|
2010-09-11
| ||
| 17:46 | Change to requirement marks in lang.in. (check-in: b5882b3f8f user: dan tags: trunk) | |
|
2010-09-10
| ||
| 19:11 | Minor changes to lang.in. (check-in: 8efac9af2b user: dan tags: trunk) | |
Changes
Changes to pages/lang.in.
2821 2822 2823 2824 2825 2826 2827 2828 2829 2830 2831 2832 2833 2834 2835 2836 2837 2838 2839 2840 2841 2842 |
the GROUP BY and HAVING clauses to the filtered input dataset.
</ul>
<p><b>4. Removal of duplicate rows (DISTINCT processing).</b>
<tcl>hd_fragment distinct</tcl>
<tcl>hd_keywords {DISTINCT}</tcl>
<p>^(One of the ALL or DISTINCT keywords may follow the SELECT keyword in a
simple SELECT statement. If neither of these are present, then the behaviour
is as if ALL were specified.)^ ^If the simple SELECT is a SELECT ALL, then the
entire set of result rows are returned by the SELECT. ^If the simple SELECT
is a SELECT DISTINCT, then duplicate rows are removed from the set of result
rows before it is returned. ^For the purposes of detecting duplicate rows,
two NULL values are considered to be equal. ^The normal rules for selecting
a collation sequence to compare text values with apply.
<h3>Compound Select Statements</h3>
<p>^A compound SELECT is formed from two or more simple SELECTs connected
by one of the operators UNION, UNION ALL, INTERSECT, or EXCEPT. ^In
a compound SELECT, all the constituent SELECTs must specify the
same number of result columns. ^There may be only a single ORDER BY
|
| < | | > | | | | > |
2821 2822 2823 2824 2825 2826 2827 2828 2829 2830 2831 2832 2833 2834 2835 2836 2837 2838 2839 2840 2841 2842 2843 |
the GROUP BY and HAVING clauses to the filtered input dataset.
</ul>
<p><b>4. Removal of duplicate rows (DISTINCT processing).</b>
<tcl>hd_fragment distinct</tcl>
<tcl>hd_keywords {DISTINCT}</tcl>
<p>^One of the ALL or DISTINCT keywords may follow the SELECT keyword in a
simple SELECT statement. ^If the simple SELECT is a SELECT ALL, then the
entire set of result rows are returned by the SELECT. ^If neither ALL or
DISTINCT are present, then the behaviour is as if ALL were specified.
^If the simple SELECT is a SELECT DISTINCT, then duplicate rows are removed
from the set of result rows before it is returned. ^For the purposes of
detecting duplicate rows, two NULL values are considered to be equal. ^The
normal rules for selecting a collation sequence to compare text values with
apply.
<h3>Compound Select Statements</h3>
<p>^A compound SELECT is formed from two or more simple SELECTs connected
by one of the operators UNION, UNION ALL, INTERSECT, or EXCEPT. ^In
a compound SELECT, all the constituent SELECTs must specify the
same number of result columns. ^There may be only a single ORDER BY
|