Difference between revisions of "Manuals/calci/DISTINCT"

Latest revision as of 16:03, 11 December 2018

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
+==Related Videos==
+{{#ev:youtube|v=IsDct4jhTVs|280|center|Distinct Subset}}
+==See Also==
+*[[Manuals/calci/DISTINCTSET| DISTINCTSET]]
+*[[Manuals/calci/DIFFERENCE| DIFFERENCE]]
+==References==
+*[https://www.w3schools.com/sql/sql_distinct.asp Distinct]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]