S

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]

scalar subqueries
     converting to composite (Oracle) 2nd 3rd
     joins and 2nd
     referencing in WHERE clause
scripts
searching
     duplicates 2nd 3rd
     for text not matching pattern (Oracle) 2nd 3rd 4th
     highest/lowest values
     Knight values
     outer joins
     results 2nd 3rd
     row values 2nd 3rd 4th
     rows 2nd 3rd
     rows from table 2nd 3rd 4th
     top n records 2nd 3rd
SECOND function (DB2)
SELECT statements
     DISTINCT keyword and
     GROUP BY and 2nd 3rd 4th
self joins
     alternatives to 2nd 3rd 4th
serialized data 2nd 3rd
set differences
set operations generally 2nd 3rd
SIGN function (MySQL/PostgreSQL)
simple
    retrieving records
         all rows/columns
         columns 2nd 3rd 4th
         null values
         pattern matching
         rows 2nd
sorting records 2nd 3rd 4th 5th 6th 7th
     by substrings
     mixed alphanumeric data
     nulls and 2nd 3rd 4th 5th 6th 7th
     on data dependent key
     on multiple fields
     on single field
     strings 2nd 3rd
specification
START WITH clause (Oracle) 2nd
Stoll
STR_TO_DATE function (MySQL)
strings
     queries 2nd
         alphabetizing
         alphanumeric status 2nd 3rd 4th 5th 6th
         extracting elements
         initials, extracting from name 2nd 3rd 4th 5th
         IP Address parsing 2nd 3rd
         numeric content 2nd 3rd 4th 5th 6th
         ordering by number 2nd 3rd 4th 5th
         parsing into rows 2nd
     searching for mixed alphanumeric 2nd
     separating numeric and character data 2nd 3rd 4th 5th
subqueries
     correlated
SUBSTR function (DB2/MySQL/Oracle/PostgreSQL) 2nd 3rd
SUBSTRING function (SQL Server) 2nd 3rd
subtotals
     calculating for all combinations
     calculating simple
     pivoting result set with 2nd
SUM function 2nd
SUM OVER window function (DB2/Oracle/SQL Server) 2nd 3rd 4th 5th
summing column values
SYS_CONNECT_BY_PATH function (Oracle) 2nd 3rd