Tag: technology

INSERT INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

INSERT Projects VALUES ('Content Development', 'Website content development project')

INSERT Projects ('Content Development', 'Website content development project')

SAVE INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

SELECT * FROM Sales

DELETE FROM Sales

SELECT * FROM SALES WHERE OrderID < 1

SELECT FROM Sales

DELETE FROM SalesData

DELETE * FROM SalesData

DELETE SalesData

DELETE ALL SalesData

To return the minimum value of a numeric expression.

To return the absolute, positive value of a numeric expression.

To return the maximum value of a numeric expression.

To return the average value of a numeric expression.

INSERT clause

SELECT clause

DELETE clause

JOIN clause

Selective Join.

You can't join a table to itself.

Self Join

Outer Join

MAX

TOP

MOST

UPPER

WHERE

SEARCH

FROM

WHILE

Determines if a value matches any of the values in a list or a sub-query.

Defines the tables we are selecting or deleting data from.

Is used with the DISTINCT SQL keyword only.

Is used to select data from a view

a special type of table

a special type of store procedure, executed when certain event occurs

a special type of view

an event