St Johns College SQL Statements and Syntax Project

Daniel Kevins

0 comments

Select one of the following SQL statements. You need to identify the statement and the syntax. Provide an example of the SQL statement using a table and attributes from the database you are designing for your data management project.

Select with Where clause

Select with Order by clause

Select with Group by clause
Select with Having clause
Select using (Count (*))
Insert
Update using columns
Update without columns identified
Delete
Create Schema
Create Table
Create View
Create Index
Alter Schema
Alter Table
Alter View
Alter Index
Drop Schema
Drop Table
Drop View
Drop Index
Create Trigger (just basic structure) you don’t have to provide example with this one
Create Procedure (just basic structure) you don’t have to provide example with this one

About the Author

Follow me