- Shopping Bag ( 0 items )
From Barnes & NobleThe Barnes & Noble Review
You need a quick SQL query. Not a lecture. You need SQL Cookbook. There are 160-plus reliable, easy-to-adapt recipes here, for everything from simple record retrieval to data warehousing. Each one’s presented and explained as simply and concisely as humanly possible. And (except for one “bonus” chapter) everything’s cross-platform: tested for DB2 v. 8, Oracle 10g, PostgreSQL 8, SQL Server 2005, and MySQL 5.
Want to sort results by substrings? Combine related rows from multiple tables? Insert a new record? Copy a table definition? List tables in a schema? Extract initials from a name? Parse an IP address? Compute a running total? Determine next year’s quarter start/end dates? Fill in missing values in a range? Rank your results? Pivot result sets into a single row? Build hierarchical queries? Don’t waste time figuring it out from scratch: It’s all right here. Bill Camarda, from the February 2006 Read Only