Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
| Comment: | Updates so that documentation agrees with requirement marks. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
f1a1831162fdf5f6c8c85d744ad83895 |
| User & Date: | drh 2019-09-27 17:55:32 |
|
2019-09-28
| ||
| 19:02 | Typo fixes. (check-in: 7a37431be5 user: drh tags: trunk) | |
|
2019-09-27
| ||
| 17:55 | Updates so that documentation agrees with requirement marks. (check-in: f1a1831162 user: drh tags: trunk) | |
| 11:30 | Merge fixes from the 3.20 branch. (check-in: de8b5d698b user: drh tags: trunk) | |
Changes to pages/lang.in.
2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 2462 2463 2464 2465 2466 2467 .... 5413 5414 5415 5416 5417 5418 5419 5420 5421 5422 5423 5424 5425 5426 .... 5438 5439 5440 5441 5442 5443 5444 5445 5446 5447 5448 5449 5450 5451 5452 5453 5454 5455 5456 5457 5458 5459 5460 5461 |
<p>^A [SELECT] statement enclosed in parentheses is a subquery. ^All types of SELECT statement, including aggregate and compound SELECT queries (queries with keywords like UNION or EXCEPT) are allowed as scalar subqueries. ^The value of a subquery expression is the first row of the result from the enclosed [SELECT] statement. ^In other words, an implied "LIMIT 1" is added to the subquery, overriding an explicitly coded LIMIT. ^The value of a subquery expression is NULL if the enclosed [SELECT] statement returns no rows. <p>A subquery that returns a single column is a scalar subquery and can be used most anywhere. ^A subquery that returns two or more columns is a [row value] subquery and can only be used as the operand of a comparison operator. ................................................................................ EXCEPT EXCLUSIVE EXCLUDE EXISTS EXPLAIN FAIL FILTER FOLLOWING FOR FOREIGN FROM FULL GLOB GROUP ................................................................................ INSTEAD INTERSECT INTO IS ISNULL JOIN KEY LEFT LIKE LIMIT MATCH NATURAL NO NOT NOTHING NOTNULL NULL OF OFFSET ON OR ORDER OTHERS OUTER |
< < > > > |
2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 2462 2463 2464 2465 .... 5411 5412 5413 5414 5415 5416 5417 5418 5419 5420 5421 5422 5423 5424 5425 .... 5437 5438 5439 5440 5441 5442 5443 5444 5445 5446 5447 5448 5449 5450 5451 5452 5453 5454 5455 5456 5457 5458 5459 5460 5461 5462 |
<p>^A [SELECT] statement enclosed in parentheses is a subquery. ^All types of SELECT statement, including aggregate and compound SELECT queries (queries with keywords like UNION or EXCEPT) are allowed as scalar subqueries. ^The value of a subquery expression is the first row of the result from the enclosed [SELECT] statement. ^The value of a subquery expression is NULL if the enclosed [SELECT] statement returns no rows. <p>A subquery that returns a single column is a scalar subquery and can be used most anywhere. ^A subquery that returns two or more columns is a [row value] subquery and can only be used as the operand of a comparison operator. ................................................................................ EXCEPT EXCLUSIVE EXCLUDE EXISTS EXPLAIN FAIL FILTER FIRST FOLLOWING FOR FOREIGN FROM FULL GLOB GROUP ................................................................................ INSTEAD INTERSECT INTO IS ISNULL JOIN KEY LAST LEFT LIKE LIMIT MATCH NATURAL NO NOT NOTHING NOTNULL NULL NULLS OF OFFSET ON OR ORDER OTHERS OUTER |