Difference between revisions of "Manuals/calci/DISTINCT"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
==Examples== | ==Examples== | ||
#DISTINCT("Bradley", "Doyle", "Doyle", "Doyle","Arthur") = Bradley Doyle Arthur | #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(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 | + | #DISTINCT("m","a","l","a","y","a","l","a","m") =m a l y |
==See Also== | ==See Also== | ||
Revision as of 16:00, 8 March 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.
,for the parameter there can be any set of values or any strings.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