Lines Matching refs:R

320 # EVIDENCE-OF: R-16074-54196 If the FROM clause is omitted from a simple
333 # EVIDENCE-OF: R-45424-07352 If there is only a single table or subquery
357 # EVIDENCE-OF: R-28355-09804 If there is more than one table or subquery
383 # EVIDENCE-OF: R-49872-03192 If the join-operator is "CROSS JOIN",
392 # EVIDENCE-OF: R-46256-57243 There is no difference between the "INNER
395 # EVIDENCE-OF: R-25071-21202 The "CROSS JOIN" join operator produces the
425 # EVIDENCE-OF: R-59089-25828 The columns of the cartesian product
445 # EVIDENCE-OF: R-44414-54710 There is a row in the cartesian product
464 # EVIDENCE-OF: R-18439-38548 In other words, if the left-hand dataset
513 # EVIDENCE-OF: R-38465-03616 If there is an ON clause then the ON
539 # EVIDENCE-OF: R-49933-05137 If there is a USING clause then each of the
551 # EVIDENCE-OF: R-22776-52830 For each pair of named columns, the
561 # EVIDENCE-OF: R-54046-48600 When comparing values as a result of a
565 # EVIDENCE-OF: R-38422-04402 The column from the dataset on the
591 # EVIDENCE-OF: R-57047-10461 For each pair of columns identified by a
595 # EVIDENCE-OF: R-56132-15700 This is the only difference between a USING
622 # EVIDENCE-OF: R-24610-05866 If the join-operator is a "LEFT JOIN" or
647 # EVIDENCE-OF: R-15607-52988 The added rows contain NULL values in the
659 # EVIDENCE-OF: R-04932-55942 If the NATURAL keyword is in the
685 # EVIDENCE-OF: R-49566-01570 If the left and right-hand input datasets
699 # EVIDENCE-OF: R-39625-59133 A USING or ON clause may not be added to a
733 # EVIDENCE-OF: R-60775-64916 If a WHERE clause is specified, the WHERE
787 # EVIDENCE-OF: R-36327-17224 If a result expression is the special
791 # EVIDENCE-OF: R-43693-30522 If the expression is the alias of a table
814 # EVIDENCE-OF: R-38023-18396 It is an error to use a "*" or "alias.*"
817 # EVIDENCE-OF: R-44324-41166 It is also an error to use a "*" or
835 # EVIDENCE-OF: R-08669-22397 The number of columns in the rows returned
863 # EVIDENCE-OF: R-20637-43463 A simple SELECT statement is an aggregate
867 # EVIDENCE-OF: R-23155-55597 Otherwise, if a simple SELECT contains no
871 # EVIDENCE-OF: R-44050-47362 If the SELECT statement is a non-aggregate
894 # EVIDENCE-OF: R-51988-01124 The single row of result-set data created
900 # EVIDENCE-OF: R-57629-25253 If the SELECT statement is an aggregate
913 # EVIDENCE-OF: R-26684-40576 Each non-aggregate expression in the
917 # EVIDENCE-OF: R-27994-60376 The same arbitrarily selected row is used
949 # EVIDENCE-OF: R-04486-07266 Or, if the dataset contains zero rows, then
961 # EVIDENCE-OF: R-64138-28774 An aggregate query without a GROUP BY
1008 # EVIDENCE-OF: R-40855-36147 If the SELECT statement is an aggregate
1018 # EVIDENCE-OF: R-25883-55063 The expressions in the GROUP BY clause do
1036 # EVIDENCE-OF: R-14926-50129 For the purposes of grouping rows, NULL
1044 # EVIDENCE-OF: R-10470-30318 The usual rules for selecting a collation
1057 # EVIDENCE-OF: R-63573-50730 The expressions in a GROUP BY clause may
1069 # EVIDENCE-OF: R-31537-00101 If a HAVING clause is specified, it is
1076 # EVIDENCE-OF: R-04132-09474 If the HAVING clause is an aggregate
1081 # EVIDENCE-OF: R-28262-47447 If a HAVING clause is a non-aggregate
1089 # EVIDENCE-OF: R-55403-13450 The HAVING expression may refer to values,
1133 # EVIDENCE-OF: R-23927-54081 Each expression in the result-set is then
1136 # EVIDENCE-OF: R-53735-47017 If the expression is an aggregate
1148 # EVIDENCE-OF: R-62913-19830 Otherwise, it is evaluated against a single
1151 # EVIDENCE-OF: R-53924-08809 If there is more than one non-aggregate
1164 # EVIDENCE-OF: R-19334-12811 Each group of input dataset rows
1167 # EVIDENCE-OF: R-02223-49279 Subject to filtering associated with the
1215 # EVIDENCE-OF: R-60770-10612 One of the ALL or DISTINCT keywords may
1223 # EVIDENCE-OF: R-08861-34280 If the simple SELECT is a SELECT ALL, then
1226 # EVIDENCE-OF: R-01256-01950 If neither ALL or DISTINCT are present,
1229 # EVIDENCE-OF: R-14442-41305 If the simple SELECT is a SELECT DISTINCT,
1247 # EVIDENCE-OF: R-02054-15343 For the purposes of detecting duplicate
1254 # EVIDENCE-OF: R-47709-27231 The usual rules apply for selecting a
1271 # EVIDENCE-OF: R-39368-64333 In a compound SELECT, all the constituent
1312 # EVIDENCE-OF: R-01450-11152 As the components of a compound SELECT must
1373 # EVIDENCE-OF: R-45440-25633 ORDER BY and LIMIT clauses may only occur
1418 # EVIDENCE-OF: R-08531-36543 A compound SELECT created using UNION ALL
1454 # EVIDENCE-OF: R-20560-39162 The UNION operator works the same way as
1472 # EVIDENCE-OF: R-45764-31737 The INTERSECT operator returns the
1480 # EVIDENCE-OF: R-25787-28949 The EXCEPT operator returns the subset of
1491 # EVIDENCE-OF: R-40729-56447 Duplicate rows are removed from the results
1501 # EVIDENCE-OF: R-46765-43362 For the purposes of determining duplicate
1530 # EVIDENCE-OF: R-51232-50224 The collation sequence used to compare two
1555 # EVIDENCE-OF: R-32706-07403 No affinity transformations are applied to
1585 # EVIDENCE-OF: R-32562-20566 When three or more simple SELECTs are
1665 # EVIDENCE-OF: R-44988-41064 Rows are first sorted based on the results
1676 # EVIDENCE-OF: R-06617-54588 Each ORDER BY expression may be optionally
1682 # EVIDENCE-OF: R-18705-33393 If neither ASC or DESC are specified, rows
1720 # EVIDENCE-OF: R-29779-04281 If the ORDER BY expression is a constant
1764 # EVIDENCE-OF: R-63286-51977 If the ORDER BY expression is an identifier
1783 # EVIDENCE-OF: R-65068-27207 Otherwise, if the ORDER BY expression is
1787 # EVIDENCE-OF: R-03421-57988 If the SELECT statement is a simple SELECT,
1805 # EVIDENCE-OF: R-28853-08147 However, if the SELECT is a compound
1847 # EVIDENCE-OF: R-10883-17697 For the purposes of sorting rows, values
1861 # EVIDENCE-OF: R-64199-22471 If the ORDER BY expression is assigned a
1872 # EVIDENCE-OF: R-09398-26102 Otherwise, if the ORDER BY expression is 
1893 # EVIDENCE-OF: R-27301-09658 Otherwise, if the ORDER BY expression is a
1904 # EVIDENCE-OF: R-49925-55905 Otherwise, the BINARY collation sequence is
1911 # EVIDENCE-OF: R-44130-32593 If an ORDER BY expression is not an integer
1973 # EVIDENCE-OF: R-39265-04070 If no matching expression can be found in
1987 # EVIDENCE-OF: R-03407-11483 Each term of the ORDER BY clause is
2034 # EVIDENCE-OF: R-30481-56627 Any scalar expression may be used in the
2047 # EVIDENCE-OF: R-46155-47219 If the expression evaluates to a NULL value
2060 # EVIDENCE-OF: R-03014-26414 If the LIMIT expression evaluates to a
2073 # EVIDENCE-OF: R-33750-29536 Otherwise, the SELECT returns the first N
2084 # EVIDENCE-OF: R-54935-19057 Or, if the SELECT statement would return
2094 # EVIDENCE-OF: R-24188-24349 The expression attached to the optional
2110 # EVIDENCE-OF: R-20467-43422 If an expression has an OFFSET clause, then
2129 # EVIDENCE-OF: R-34648-44875 Or, if the SELECT would return less than
2139 # EVIDENCE-OF: R-23293-62447 If the OFFSET clause evaluates to a
2149 # EVIDENCE-OF: R-19509-40356 Instead of a separate OFFSET clause, the
2152 # EVIDENCE-OF: R-33788-46243 In this case, the first expression is used