Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in Lyftron. Use these statements to add, modify, query, or remove data from a database.
The following table lists the DML statements that Lyftron uses.
|SELECT Statement||Retrieves rows from the database and enables the selection of one or many rows or columns from one or many tables.|
|SELECT Clause||Specifies the columns to be returned by the query.|
|SELECT Examples||This topic provides examples of using the SELECT statement.|
|SELECT Group By||A SELECT statement clause that divides the query result into groups of rows, usually for the purpose of performing one or more aggregations on each group.|
|SELECT Having||Specifies a search condition for a group or an aggregate. HAVING can be used only with the SELECT statement. HAVING is typically used with a GROUP BY clause.|
|SELECT Order By||Sorts data returned by a query in Lyftron.|
|SELECT Over||Determines the partitioning and ordering of a rowset before the associated window function is applied.|
|FROM||Specifies the tables, views, derived tables, and joined tables used in DELETE, SELECT, and UPDATE statements in Lyftron|
|WHERE||Specifies the search condition for the rows returned by the query.|
|Hints||Hints are options or strategies specified for enforcement by the query processor on statements. The hints override any execution plan the query optimizer might select for a query.|
|OPTION clause||Specifies that the indicated query hint should be used throughout the entire query. Each query hint can be specified only one time, although multiple query hints are permitted. Only one OPTION clause can be specified with the statement.|
|Predicates||Predicates are truth-tests. If the predicate test is true, it returns a value. Each predicate is evaluated per row so that when the predicate is part of an entire table SELECT statement, the statement can return multiple results.|
|TOP||Limits the rows returned in a query result set to a specified number of rows or percentage of rows in Lyftron.|