SQL Cookbook

Type Book

Rate 0.0 /5

This convenient guide is for anyone who wants to take his or her SQL skills to the next level. Packed with over 200 recipes, the SQL Cookbook helps you conquer common data query and manipulation problems, including those related to window functions, data warehousing, and string manipulation. Features an easy-to-grasp problem-solution-discussion format.

Details

Files

Reviews

Download

Title Statements

Full title :SQL Cookbook.

Summary

Edition Statements

Publication Date:2009.

Publication Statements

Publisher(s):O'Reilly Media, Inc
Place of Publication:Sebastopol
Language:eng
Publication Date:2009.

The Physical Object

Description:1 online resource (1169 pages)

Edition Identifiers

ISBN:9780596555016, 0596555016
oclc:ocn535990023
LC Classification:QA76.73.S67
Dewey Decimal:005.7585

SQL Cookbook; Objectives of This Book; Audience for This Book; How to Use This Book; What & s Missing from This Book; Structure of This Book; Platform and Version; Tables Used in This Book; Conventions Used in This Book; Coding Conventions; Using Code Examples; Comments and Questions; Safari® Enabled; Acknowledgments; 1. Retrieving Records; Solution; Discussion; 1.2. Retrieving a Subset of Rows from a Table; Solution; Discussion; 1.3. Finding Rows That Satisfy Multiple Conditions; Solution; Discussion; 1.4. Retrieving a Subset of Columns from a Table; Solution; Discussion.

1.5. Providing Meaningful Names for ColumnsSolution; Discussion; 1.6. Referencing an Aliased Column in the WHERE Clause; Solution; Discussion; 1.7. Concatenating Column Values; Solution; MySQL; SQL Server; Discussion; 1.8. Using Conditional Logic in a SELECT Statement; Solution; Discussion; 1.9. Limiting the Number of Rows Returned; Solution; MySQL and PostgreSQL; Oracle; SQL Server; Discussion; 1.10. Returning n Random Records from a Table; Solution; MySQL; Postg.