4 DML (Data manipulation Language) commands (SELECT INSERT UPDATE DELETE)
The query syntax has a unique fixed order
Select-from-where-group By-having-order by
3. FROM clause data source
- Local SQL Server table . (The number of tables that can be accessed in a single SQL SELECT statement cannot exceed 256)
- A subquery is a derived table, also known as a sub-selection or inline view.
- view or a stored SELECT statement.
- table-valued user-defined functions return rows and columns.
- Distributed Data Sources use OPENQUERY () and other distributed functions from other SQL Server databases, other SQL Servers, other database platforms (such as Microsoft Access, Oracle, and FoxPro), or applications ( such as Excel) to extract the data.
- Full-text search can return datasets that contain information about which rows include specific words.
- Perspective creates a crosstab within the FROM clause.
- The XML data source uses XQuery.
- The Row constructor uses the values () clause to construct hard-coded rows.
- For inserted and deleted virtual tables from INSERT, UPDATE, or delete commands, you can use the output clause to pass them to an external query as a subquery.
Basic query Flow "MSSQL"