You know the basics of SQL query language, but you feel you do not take full advantage of SQL's expressive power. Let's face it, SQL is the language that seems simple to learn, and many database developers never go far beyond the simple statement: SELECT column FROM table WHERE condition. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. If you do not use this, you're missing outPowerful, features a database-specific, such as SQL Server's PIVOT and operators UNPIVOT, Oracle's MODEL clause, and GENERATE_SERIES PostgreSQL very useful functionPivoting line to the column, column, reverse-spin to a line, use the spin to facilitate the calculation of inter- lines, and double-spin effect Bucketization set, and why you may not use the term in Brooklyn.How to create histograms, summarize data into buckets, perform aggregations moving range of values, generate running-totals and subtotals, and advanced, data warehousing techniques techniquesThe running string, which allows you to use SQL to parse through the characters, words, or elements separated by a string Written in O'Reilly's popular Problem / Solution / Discussion style, the SQL Cookbook is sure to please.