Topics

• SELECT
• Window Functions
• Parse comma-separated values in a column into multiple rows

Examples

• Select columns which are named after reserved keywords
• Selecting without Locking the table
• Recursive query to parse comma-separated values
• Finding "out-of-sequence" records using the LAG() function