About this document
Advanced SQL Concepts and Functions by hughston.musashi is a document available to read on EtoBox.
The document provides an overview of advanced SQL topics including timestamps and extracting date/time information, mathematical functions, string functions, subqueries, and self-joins. It discusses functions like EXTRACT(), NOW(), and TO_CHAR() for working with timestamps. It provides examples of how to perform calculations and extract date/time fields from columns. It also demonstrates how to use subqueries to select rows based on the results of another query, and how self-joins can be used to compare col
- Author
- hughston.musashi
- Language
- EN