No credit card required
The result table of a query has columns and rows. It is a table and it can be handled like any other table. This chapter shows you how to save the results of a query in a new table and make modifications to the data.
Saving Your Results in a New Table or View
Create a new table from the result of a select statement
Creating a new view from the results of a select statement
Similarities between tables and views
Differences between tables and views
Deleting a table
Deleting a view
One view can be built on top of another view
Modifying the Data in a Table with SQL
Adding one new row to a table
Adding many new rows to a table
Changing data ...