R

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [Y] [Z]

RAND function
RANDOM function
random records 2nd
RANGE BETWEEN clause 2nd 3rd 4th
ranges
     consecutive 2nd
     consecutive numeric values
     differences between rows in group 2nd 3rd 4th 5th
     missing values 2nd
RATIO_TO_REPORT function (Oracle)
reciprocal rows 2nd
referential integrity
REGEXP_REPLACE function (Oracle)
Regular Expression Anti-Patterns(Gennick)
regular expressions (Oracle) 2nd
relational division
REPEAT function (DB2)
REPLACE function 2nd 3rd 4th 5th
REPLICATE function (SQL Server)
result set 2nd 3rd 4th 5th
retrieving data from
    multiple tables
         adding joins to existing joins
         columns with same data type
         finding common rows
         nonmatching rows
         NULLs in operations/comparisons
         related rows
retrieving records
     complex
         aggregating groups/partitions simultaneously
         aggregating over moving value range 2nd 3rd 4th
         fixed size groups
         histograms, horizontal 2nd
         non-GROUP BY columns, returning 2nd 3rd 4th 5th 6th
         repeating values, suppressing 2nd
         sparse matrices
         subtotals 2nd
     simple
         random 2nd
reverse pivoting result sets 2nd 3rd
ROLLUP extension of GROUP BY(DB2/Oracle) 2nd 3rd
row generation 2nd 3rd 4th
ROW_NUMBER function (DB2/SQL Server)
ROW_NUMBER OVER window function (DB2/Oracle/SQL Server)
     ORDER BY clause and
     uniqueness of result
     uses 2nd
ROWNUM function (Oracle) 2nd 3rd
RPAD function (Oracle)
RTRIM function (Oracle/PostgreSQL)
RULES subclause (Oracle)
running differences
running products 2nd 3rd 4th
running totals 2nd 3rd 4th 5th 6th
Russell
Russell's Paradox