SQL. Collection of Recipes

This book presents ready-made recipes for solving practical tasks when working with DBMS Oracle, DB2, SQL Server, MySQL, and PostgreSQL. It describes extracting records from tables, sorting query results, principles for working with multiple tables, handling queries with metadata. It... discusses methods for data searching using SQL, preparing reports, and formatting resulting sets, and working with hierarchical queries. It covers the use of window functions, common table expressions (CTEs), collecting data into blocks, forming histograms, current sums and subtotals, and aggregating a sliding range of values. It describes traversing a string and its syntactic parsing into characters, providing methods for simplifying calculations within a string.
In the second edition, all changes in syntax and architecture of current SQL implementations have been taken into account.
For programmers, developers, and database administrators.