Number Of Pages: 640
Publication Date: December 16, 2005
Publisher: O'Reilly Media
Format: chm
Size: 674 KB
Book Description:
In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:
Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out
Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function
Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set
How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques
The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string
SQL Cookbook
On
11:57 AM
0
comments
Categories:
SQL
Subscribe to:
Post Comments (Atom)
0 Response for the "
SQL Cookbook
"Post a Comment