Data Retrieval INTERSECT Intersect is used to retrieve the records that are identical/common between the result sets of two tables. The query is “SELECT (tables) statements.” For example: DISTINCT This statement is used to return only distinct (unique) values. Inside a table, a column often contains many duplicate values. For example: ALIAS Alias are used to give a table, or a column in a table, a temporary name. Aliases are often used to make column names more readable.
Code example in column : Code example in table : COMPUTED COLUMN Computed column is a virtual column that is not physically stored in the table, unless the column is marked PERSISTED. SORT Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively.
Code Example : IF you are not typing ASC or DESC, the code will be ASC as default syntax. Another example :