writer
6,694
edits
Changes
no edit summary
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 ]]