DML Glossary
B D E G I L N O S T U W - B
- Between - Matches values that fall within a given range.
- D
- Declare - Declares a variable for the rest of a script.
- Delete - Delete removes the documents that match the given criteria.
- Distinct - Removes duplicate rows from the results of a SELECT.
- DML Glossary - A catalog of DML related topics.
- E
- Exec - Exec runs a system procedure.
- Expressions - Literals, operators, comments and variables in KBSQL.
- G
- Group By - Group by collapses a result set into one row per distinct set of values.
- I
- Inner Join - Combines documents from two or more schemas based on matching fields.
- Insert - Insert creates new documents in a schema.
- L
- Left Outer Join - Combines documents from two or more schemas, keeping documents that have no match.
- Like - Allows basic pattern matching in a where clause.
- List - Lists the documents or child schemas of a schema.
- Logical Connectors - Connects one logical expression to another.
- N
- Not - The NOT keyword negates LIKE and BETWEEN.
- O
- Offset - Skips a number of rows of an ordered result, for paging.
- Order By - Order by sorts a result set by a given set of fields or expressions.
- S
- Sample - Returns a random sample of documents from a schema.
- Select - Select statements are used to read (or query) data from the database.
- Select Into - Creates a schema and fills it with the results of a SELECT.
- Single - A built-in schema containing exactly one document, used to evaluate constant expressions.
- System Procedures - Built-in procedures for inspecting and managing the database engine.
- T
- Top - The TOP keyword limits the number of results that are returned by a query.
- Transaction - Transactions make a group of statements all-or-nothing.
- U
- Update - Update changes fields of existing documents.
- W
- Where - The where clause filters the documents read, updated or deleted by a statement.