RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
Into Statement
«Prev
Next»
SQL Introduction
Course Prerequisites
Select Statement
What is SQL
Client/Server Request
SQL 92 (History)
SQL Dialect Variations
Relational Databases
Relational vs Flatfile
Different Storage Formats
Relational DB Analogy
Database Normalization
Data Table Example
Normalization Example Table
Table Normalization - Exercise
Three Normalization Levels
Relational Flatfile DB
SQL Columns Rows
SQL Foundations
Database Elements
Database Parts - Quiz
Database Spreadsheets
Databases Column Types
Create Index Column
SQL Select Statement
Selecting Information
Database Foundations - Quiz
Table Querying
SQL Conclusion
INTO Statement
Order By Clause
SQL Into Statement
Filtering Select Statement
Joining Tables
SQL INTO clause - Exercise
Using the
INTO
clause
Objective:
Create a statement that will move a filtered cross-section of information from Customer Table to AZ_Customers Table.
Given the following table, named Customer:
Lastname
Firstname
PhoneNumber
ZIP Code
State
Wynsoup
Stephen
520-555-1212
85744
AZ
Brennan
Jeffrey
123-321-5678
04325
CA
Caitlin
Elizabeth
444-231-5642
95439
WA
Wynsoup
Julie
201-453-7641
85744
AZ
Andrews
Julie
309-123-4567
85744
AZ
Create a statement that will make a copy of rows that represent Arizona (state code is AZ) and place them in a new table, AZ_Customers. When you are done, submit your statement .
Submit