D

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]

data dependent keys
data dictionary views (Oracle)
DATE function (DB2)
DATE_ADD function (MySQL) 2nd 3rd 4th 5th
DATE_FORMAT function (MySQL) 2nd 3rd 4th 5th
DATE_TRUNC function (PostgreSQL) 2nd 3rd 4th 5th
DATEADD function (MySQL)
DATEADD function (SQL Server) 2nd 3rd
DATEDIFF function (MySQL/SQL Server) 2nd 3rd 4th 5th
DATENAME function (SQL Server) 2nd 3rd 4th 5th
DATEPART function (SQL Server) 2nd 3rd 4th 5th
dates
     arithmetic 2nd
         business days between dates 2nd 3rd 4th 5th 6th
         difference between record and next record 2nd 3rd 4th
         weekdays in year, counting 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
     format
     manipulation
         calendar 2nd 3rd 4th 5th 6th 7th
         comparing records
         date ranges, identifying overlapping 2nd 3rd 4th 5th
         leap year 2nd 3rd 4th 5th 6th 7th 8th
         missing dates 2nd 3rd 4th 5th 6th 7th 8th 9th
         quarter start/end dates 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
         weekdays, first/last in month 2nd
         year 2nd 3rd 4th
     ORDER BY clause and (DB2)
DAY function (DB2) 2nd 3rd
DAY function (MySQL) 2nd 3rd 4th
DAY function (SQL Server) 2nd 3rd
DAYNAME function (DB2/MySQL/SQL Server) 2nd
DAYOFWEEK function (DB2/MYSQL) 2nd 3rd
DAYOFYEAR function (DB2/MySQL/SQL Server) 2nd 3rd 4th 5th
DAYS function (DB2) 2nd 3rd
DB2
     DATE values in ORDER BY clause
DECODE function (Oracle) 2nd
DEFAULT keyword
DEFAULT VALUES clause (PostgreSQL/SQL Server)
DELETE command 2nd
deleting records
     all
     duplicate
     referenced from another table
     single
     specific
     that violate integrity
     with NULLs (DB2/Oracle/SQL Server)
     with NULLs (PostgreSQL/MySQL) 2nd
delimited data 2nd
delimited lists 2nd 3rd 4th 5th 6th
DENSE_RANK function (DB2/Oracle/SQL Server) 2nd 3rd
DENSE_RANK OVER window function (DB2/Oracle/SQL Server) 2nd 3rd 4th
DISTINCT keyword
     alternatives to 2nd
     SELECT list and 2nd 3rd
     uses for 2nd 3rd
duplicates
     deleting
     suppressing 2nd
dynamic SQL