L'operatore SQL UNION combina i risultati di due o più query e fa un set di risultati che include le righe prelevato dalla query partecipano all'Unione.

In this page we are going to discuss, how two or more tables can be involved as an alias and join themselves to make a view in CREATE VIEW statement.

In this page, we are discussing the usage of DISTINCT clause and aggregate functions and operators with the select statement, resultant a subquery, which helps to make a VIEW in a CREATE VIEW statement.

In this page we are discussing about the usage of DISTINCT clause. in a subquery.

In this page we are going to discuss the usage of SQL DISTINCT command along with the SQL SQRT() function to retrieve only unique data from the table depending on the specified column or expression.

In this page we are going to discuss the usage of SQL DISTINCT command along with the SQL POWER() function to retrieve only unique data depending on a specified expression.

In this page we are going to discuss the usage of the SQL DISTINCT command along with the SQL MOD() function to retrieve only unique records depending on the column or expression specified.

In this page we are going to discuss the usage of SQL DISTINCT along with the SQL FLOOR() function to retrieve only unique value after rounded down to the next least integer value depending on the column specified.

In this page we are going to discuss the usage of DISTINCT clause along with the SQL CEIL() function to get the distinct value of a specific number of column of a table after rounded up upwards.

In this page we are going to discuss the usage of DISTINCT clause along with the SQL ABS() to find the distinct absolute value.