publishers Table
by Sandra L. Emerson, Marcy Darnovsky, Judith S. Bowman
Practical SQL Handbook, The: Using SQL Variants, Fourth Edition
- Copyright
- List of Figures
- Foreword to the Fourth Edition
- Preface
- Introduction
- SQL and Relational Database Management
- Designing Databases
- Creating and Filling a Database
- Selecting Data from the Database
- Sorting Data and Other Selection Techniques
- Grouping Data and Reporting from It
- Joining Tables for Comprehensive Data Analysis
- Structuring Queries with Subqueries
- What Is a Subquery?
- How Do Subqueries Work?
- Joins or Subqueries?
- Subquery Rules
- Subqueries Returning Zero or More Values
- Subqueries Returning a Single Value
- Subqueries Testing Existence
- Subqueries in Multiple Levels of Nesting
- Subqueries in UPDATE, DELETE, and INSERT Statements
- Subqueries in FROM and SELECT Clauses
- Summary
- Creating and Using Views
- Security, Transactions, Performance, and Integrity
- Solving Business Problems
- Syntax Summary for the SQL Used in This Book
- Industry SQL Equivalents
- Glossary
- The bookbiz Sample Database
- Resources
- CD ROM Warranty
- Using the Practical SQL Handbook CD
publishers Table
The publishers table has three rows, representing three publishing lines in bookbiz. The pub_id and state columns are fixed character datatype. All the other columns are variable character datatype. There is a unique index on pub_id called pubind.
pub_id pub_name address city state not null null null null null pubind ====== ===================== ============== ================= ===== 0736 New Age Books 1 1st St. Boston MA 0877 Binnet & Hardley 2 2nd Ave. Washington DC 1389 Algodata Infosystems 3 3rd Dr. Berkeley CA
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.