About this document
SQL Table Creation and Manipulation Guide by Santosh Avhad is a document available to read on EtoBox.
The document contains SQL statements to: 1) Create a table called sql_BB12 with columns for employee data and insert several records. 2) Add a column to sql_BB12, truncate and drop the table multiple times. 3) Perform select queries on sql_BB12 with filters, ordering, aggregation functions and joins to other tables. 4) Create additional tables sql_012 and sql_056 linked to sql_BB12 via foreign keys and insert records. 5) Perform full outer joins between the tables and select columns from the joined results
- Author
- Santosh Avhad
- Language
- EN