SQL Cookbook
You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.\ Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is...
Search in google:
For anyone writing SQL in a professional environment, this book presents a compendium of solutions that readers can immediately apply to commonly-faced, real-world data query and manipulation problems.
1Retrieving records12Sorting query results143Working with multiple tables284Inserting, updating, deleting625Metadata queries836Working with strings957Working with numbers1558Date arithmetic1889Date manipulation21910Working with ranges29811Advanced searching32512Reporting and warehousing36513Hierarchical queries44114Odds 'n' ends471AWindow function refresher525BRozenshtein revisited551
\ 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\ \ \
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
