Difference between revisions of "Manuals/calci/DISTINCT"

Revision as of 14:53, 23 March 2017

DISTINCT ()

This function shows the distinct values from the given array.
In $DISTINCT()$ ,for the parameter there can be any set of values or any strings.
This statement is used to return only distinct (different) values.
Suppose in the given values,it may contain many duplicate values and sometimes there is need of any different (distinct) values.
The DISTINCT keyword can be used to return only distinct (different) values.

@@ Line 1: / Line 1: @@
-distinct
+<div style="font-size:30px">'''DISTINCT () '''</div><br/>
+==Description==
+*This function shows the distinct values from the given array.
+*In <math>DISTINCT()</math>,for the parameter there can be any set of values or any strings.
+*This statement is used to return only distinct (different) values.
+*Suppose in the given values,it may  contain many duplicate values and sometimes there is need of any different (distinct) values.
+*The DISTINCT keyword can be used to return only distinct (different) values.
+==Examples==
+#DISTINCT("Bradley", "Doyle", "Doyle", "Doyle","Arthur") = Bradley Doyle Arthur
+#DISTINCT(30,23,65,10,0,-5,30,65,0) = 0	10	23	30	65	-5
+#DISTINCT("m","a","l","a","y","a","l","a","m") m a l y
+==See Also==
+*[[Manuals/calci/DISTINCTSET| DISTINCTSET]]
+*[[Manuals/calci/DIFFERENCE| DIFFERENCE]]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]
+==References==
+*[https://www.w3schools.com/sql/sql_distinct.asp Distinct]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]