A Select Statement retrieves data from one or more database tables or database views. In most applications, Select is the most commonly used data manipulation language (DML) command. As SQL is a declarative programming language, Select queries specify a result set, but do not specify how to calculate it.
- Select syntax
- Use condition where
- Example with sum()
- Use of squared brackets
In our documentation you will find an illustrated step-by-step guide to the topic “Select Statement”: https://docs.ninox.com/en/script/introduction-to-ninox-script/select-and-query-specific-records