Keywords
Table of Contents
The statements and clauses supported by Katzebase, grouped by purpose.
- Select
- Distinct
- Top
- Select Into (SELECT ... INTO)
- Where
- Group By
- Order By (Asc, Desc)
- Offset
- Inner Join
- Outer Join
- Sample
- List
- Create Index
- Create UniqueKey
- Drop Index / Drop UniqueKey
- Rebuild Index / Rebuild UniqueKey
- Analyze Index
- Exec (Execute)
- Kill
- System Procedures
These keywords and options were part of older versions of Katzebase and are no longer supported:
- Create Procedure / Drop Procedure (not currently available)
- PageSize
- Partitions
SQL :: Median
Returns the median (middle) value in each group. For an even number of values it is the average of the two middle values.
SQL :: Min
Returns the smallest numeric value in each group. Use MinString for text.
SQL :: MinString
Returns the alphabetically smallest value in each group.
SQL :: Mode
Returns the value that occurs most often in each group. When several values are tied, the first one encountered is returned.
SQL :: Not
The NOT keyword negates LIKE and BETWEEN.
SQL :: Offset
Skips a number of rows of an ordered result, for paging.
SQL :: Order By
Order by sorts a result set by a given set of fields or expressions.
SQL :: PageSize
Removed: schemas no longer have a page size.
SQL :: Partitions
Removed: index partitions no longer apply.
SQL :: Print
Evaluates an expression and returns the result as a message with the query results.