Tag: databases

UPDATE

SELECT

INSERT

INVERT

insert and delete only

update and delete only

update, delete and insert

insert and update only

SELECT * FROM Products ORDER BY ProductID

SELECT * FROM Products WHERE ProductID > 200

SELECT * FROM Products ORDERED BY ProductID

SELECT ProductID FROM Products

Selects all Customers from the Sales table

Selects all customers from table Sales that have made more than 5 orders.

Selects the total number of orders from the Sales table, if this number is greater than 5

Selects no records

The foreign key is a column that can have NULL values.

The foreign key is a SQL locking mechanism.

A foreign key is a key field (column) in a database table, which relates the table to another table where the key is a primary key. The primary - foreign key relations are used to cross-reference database tables.

The foreign key is a column that should be primary key for that table.

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

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

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

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

SELECT FROM Sales WHERE Date BETWEEN ('10/12/2005', '01/01/2006')

SELECT * FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

SELECT FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

SELECT * FROM Sales WHERE Date BETWEEN ('10/12/2005', '01/01/2006')

Self Join

Selective Join.

Outer Join

You can't join a table to itself.

GROWN

FROM

UPDATING

DELETING

Use SELECT COUNT(*)...in db2 query

Use SELECT DISTINCT...in db2 query

Use SELECT MAX(...)...in db2 query

Use SELECT ROWNUM(*)...in db2 query