SQL. Collection of recipes

Book Anthony Molinaro SQL. A collection of recipes is intended to those who are already familiar with the basics of the SQL query language and want to increase their professional level. It will also be useful and SQL experts, as the author offers task solutions options for different DBMS: DB2, Oracle, PostgreSQL, MySQL and SQL Server. If you are constantly working with SQL on one platform, you may find a more effective solution to another in recipes. You will learn how to use SQL to solve a wider range of tasks - from operations within databases before data transmission over the network in the application. To do this, just open the book on the page with the recipe you are interested in.
You will learn how to apply window functions and special operators, as well as advanced methods of working with data warehouses: Creating histograms, data alignment into blocks, performing the aggregation of the sliding range of values, forming current sums and arms. You can deploy strings to columns and vice versa, simplify the calculations inside the string and perform a double deployment of the resulting set, to carry out a row bypass, which allows you to use SQL to syntactically parsing a string to characters, words or elements of a string with separators. The techniques offered by the author will optimize the code of your applications and open the new SQL language features before you