Select
Overview
Select statements are used to read (or query) data from the database.
Notes on SELECT *
Select * can be used to obtain all fields from the selected documents. Notes that since the fields are not guaranteed to be consistent across all documents in the schema, that select * can be quite inefficient since extra locking is required as the cononical model is materialized.Inconsitent Schema Fields
Fields are not guaranteed to be consistent across all documents in the schema, any fields that are referenced will be selected but will be NULL for documents where the field does not exist.Examples
SELECT
*
FROM
WordList:Word
SELECT
Id, Text, LanguageId
FROM
WordList:Word
SELECT
Id, Text, LanguageId
FROM
WordList:Word
WHERE
Text = 'Summary'
Related
- Keywords - A breakdown of all high-level statements available via the query handler.