SQL pocket guide
If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1,...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly
2011.
|
| Edición: | 3rd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628076906719 |
Tabla de Contenidos:
- Table of Contents; Chapter 1. SQL Pocket Guide; Introduction; Organization of This Book; Platform notes; Conventions; Example Data; Using Code Examples; How to Contact Us; Safari® Books Online; Acknowledgments; Analytic Functions; CASE Expressions: Simple; CASE Expressions: Searched; CAST Function; CONNECT BY Queries; Core CONNECT BY Syntax; Creative CONNECT BY; WHERE Clauses with CONNECT BY; Joins with CONNECT BY; Sorting CONNECT BY Results; Loops in Hierarchical Data; Supporting Functions and Operators; Data Type Conversion; Data Types: Binary Integer; Data Types: Character String
- Data Types: DatetimeDB2; MySQL; Oracle; PostgreSQL; SQL Server; Data Types: Decimal; DB2's DECFLOAT Type; DECIMAL/NUMBER Type; Datetime Conversions: DB2; Datetime Conversions: MySQL; Date and Time Elements; TO_DAYS and FROM_DAYS; Unix Timestamp Support; Seconds in the Day; DATE_FORMAT and TIME_FORMAT; Datetime Conversions: Oracle; Datetime Conversions: PostgreSQL; Datetime Conversions: SQL Server; CAST and SET DATEFORMAT; CONVERT; DATENAME and DATEPART; DAY, MONTH, and YEAR; Datetime Functions: DB2; Datetime Functions: MySQL; Datetime Functions: Oracle; Getting Current Date and Time
- Rounding and TruncatingOther Oracle Datetime Functions; Datetime Functions: PostgreSQL; Getting Current Date and Time; Rounding and Truncating; Other PostgreSQL Datetime Functions; Datetime Functions: SQL Server; Deleting Data; Deleting in Order; Deleting All Rows; Deleting from Views and Subqueries; Returning Deleted Data: DB2; Returning Deleted Data: Oracle; Returning Deleted Data: SQL Server; Double-FROM; EXTRACT Function; GREATEST; Grouping and Summarizing; Aggregate Functions; GROUP BY; Listing the Detail Values; Reducing the GROUP BY List; Grouping Before the Join; HAVING; ROLLUP; CUBE
- GROUPING SETSRelated Functions; Hierarchical Queries; Recursive WITH; Tracking Your Depth; Breadth-First Versus Depth-First Sorting; Detecting Recursive Loops; Indexes, Creating; Indexes, Removing; Inserting Data; Single-Row Inserts; Multirow Inserts; Insert Targets; Subquery Inserts; Returning Inserted Values: DB2; Returning Inserted Values: Oracle; Returning Inserted Data: SQL Server; Multitable Inserts; Unconditional multitable insert; Conditional multitable insert; ALL versus FIRST; Joining Tables; The Concept of a Join; Cross Joins; Inner Joins; The USING Clause; Natural Joins
- Non-Equi-JoinsOuter Joins; Left outer joins; Interpreting nulls in an outer join; Right outer joins; Full outer joins; Vendor-specific outer join syntax; LEAST; Literals; Text Literals; Numeric Literals; Datetime Literals; Datetime Interval Literals; Merging Data; Nulls; Predicates for Nulls; Using CASE with Nulls; Using the COALESCE Function; Functions for Nulls: DB2; Functions for Nulls: MySQL; Functions for Nulls: Oracle; Functions for Nulls: PostgreSQL; Functions for Nulls: SQL Server; Numeric Conversions: DB2; Numeric Conversions: MySQL; Numeric Conversions: Oracle
- Numeric Conversions: PostgreSQL
