CS3402 Introduction to SQL
SQL
- DDL: Create Table, Drop Table
- DML: Select, Insert, Delete, Update
Select Col_1,Col_2,...,Col_n - what to return
From Rel_1,Rel_2,...,Rel_m - relation
Where Boolean Condition - combine filter
SQL
Select Col_1,Col_2,...,Col_n - what to return
From Rel_1,Rel_2,...,Rel_m - relation
Where Boolean Condition - combine filter