Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Remove the tags from a couple of untestable statements in lang_select.html. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
0df9f2d38140ae2f82cf06f4abb16798 |
User & Date: | dan 2010-09-18 15:03:00.000 |
Context
2010-09-18
| ||
18:52 | Tweaks to lang_insert.html. (check-in: 15cc2204a5 user: dan tags: trunk) | |
15:03 | Remove the tags from a couple of untestable statements in lang_select.html. (check-in: 0df9f2d381 user: dan tags: trunk) | |
2010-09-17
| ||
19:52 | Update the syntax diagram GIF files. (check-in: 2adf0c0cca user: drh tags: trunk) | |
Changes
Changes to art/syntax/bubble-generator-data.tcl.
︙ | ︙ | |||
210 211 212 213 214 215 216 | } delete-stmt-limited { stack {line DELETE FROM qualified-table-name {optx WHERE expr}} {optx {stack {optx ORDER BY {loop ordering-term ,}} | | | 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 | } delete-stmt-limited { stack {line DELETE FROM qualified-table-name {optx WHERE expr}} {optx {stack {optx ORDER BY {loop ordering-term ,}} {line LIMIT /expr {optx {or OFFSET ,} /expr}} } } } detach-stmt { line DETACH {optx DATABASE} /database-name } drop-index-stmt { |
︙ | ︙ | |||
320 321 322 323 324 325 326 | } } } select-stmt { stack {loop {line select-core nil} {nil compound-operator nil}} {optx ORDER BY {loop ordering-term ,}} | | | 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 | } } } select-stmt { stack {loop {line select-core nil} {nil compound-operator nil}} {optx ORDER BY {loop ordering-term ,}} {optx LIMIT /expr {optx {or OFFSET ,} /expr}} } select-core { stack {line SELECT {or nil DISTINCT ALL} {loop result-column ,}} {optx FROM join-source} {optx WHERE expr} {optx GROUP BY {loop ordering-term ,} {optx HAVING expr}} |
︙ | ︙ | |||
388 389 390 391 392 393 394 | stack {line UPDATE {opt OR {or ROLLBACK ABORT REPLACE FAIL IGNORE}} qualified-table-name} {line SET {loop {line /column-name = expr} ,} {optx WHERE expr}} {optx {stack {optx ORDER BY {loop ordering-term ,}} | | | 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 | stack {line UPDATE {opt OR {or ROLLBACK ABORT REPLACE FAIL IGNORE}} qualified-table-name} {line SET {loop {line /column-name = expr} ,} {optx WHERE expr}} {optx {stack {optx ORDER BY {loop ordering-term ,}} {line LIMIT /expr {optx {or OFFSET ,} /expr}} } } } qualified-table-name { line {optx /database-name .} /table-name {or nil {line INDEXED BY /index-name} {line NOT INDEXED}} } |
︙ | ︙ |
Changes to pages/lang.in.
︙ | ︙ | |||
2590 2591 2592 2593 2594 2595 2596 | BubbleDiagram join-op BubbleDiagram join-constraint BubbleDiagram ordering-term BubbleDiagram compound-operator </tcl> | | | 2590 2591 2592 2593 2594 2595 2596 2597 2598 2599 2600 2601 2602 2603 2604 | BubbleDiagram join-op BubbleDiagram join-constraint BubbleDiagram ordering-term BubbleDiagram compound-operator </tcl> <p>The SELECT statement is used to query the database. The result of a SELECT is zero or more rows of data where each row has a fixed number of columns. <p>The SELECT statement is the most complicated command in the SQL language. To make the description easier to follow, some of the passages below describe the way the data returned by a SELECT statement is determined as a series of steps. It is important to keep in mind that this is purely illustrative - |
︙ | ︙ | |||
2623 2624 2625 2626 2627 2628 2629 | The set of result rows is computed by aggregating the data according to any GROUP BY clause and calculating the result-set expressions for the rows of the filtered input dataset. <li> <p>[DISTINCT|DISTINCT/ALL keyword] processing: If the query is a "SELECT DISTINCT" query, duplicate rows are removed from the set of result rows. </ol> | | | 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 | The set of result rows is computed by aggregating the data according to any GROUP BY clause and calculating the result-set expressions for the rows of the filtered input dataset. <li> <p>[DISTINCT|DISTINCT/ALL keyword] processing: If the query is a "SELECT DISTINCT" query, duplicate rows are removed from the set of result rows. </ol> <p>There are two types of simple SELECT statement - aggregate and non-aggregate queries. ^A simple SELECT statement is an aggregate query if it contains either a GROUP BY clause or one or more aggregate functions in the result-set. ^Otherwise, if a simple SELECT contains no aggregate functions or a GROUP BY clause, it is a non-aggregate query. <p><b>1. Determination of input data (FROM clause processing).</b> <tcl>hd_fragment fromclause</tcl> |
︙ | ︙ |