Difference between revisions of "Manuals/calci/DISTINCT"
(Created page with "distinct") |
|||
| (4 intermediate revisions by the same user not shown) | |||
| 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 ]] | ||
Latest revision as of 15:03, 11 December 2018
DISTINCT ()
Description
- This function shows the distinct values from the given array.
- In ,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