Difference between revisions of "Manuals/calci/DIFFERENCE"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''DIFFERENCE(GivenSet1,GivenSet2)'''</div><br/> *where <math>GivenSet1,GivenSet2</math> are the arrays for which difference is to be found. ==Des...") |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 7: | Line 7: | ||
*DIFFERENCE function will consider text, numbers, or any special characters like @,&... | *DIFFERENCE function will consider text, numbers, or any special characters like @,&... | ||
*Input other than numbers should be given in quotes. | *Input other than numbers should be given in quotes. | ||
| − | |||
==Examples== | ==Examples== | ||
| Line 13: | Line 12: | ||
#DIFFERENCE(["@","&","*"],["@","&","*"]) = '' | #DIFFERENCE(["@","&","*"],["@","&","*"]) = '' | ||
#DIFFERENCE([1,2,3,"a","@","&","*"],["@","&","*"]) = 1 2 3 a | #DIFFERENCE([1,2,3,"a","@","&","*"],["@","&","*"]) = 1 2 3 a | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=4jE7wSY6q0Y|280|center|Difference}} | ||
| + | |||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/DISTINCT| DISTINCT]] | ||
| + | *[[Manuals/calci/DISTINCTSET| DISTINCTSET]] | ||
| + | |||
| + | ==References== | ||
| + | *[https://www.w3schools.com/sql/sql_distinct.asp Difference] | ||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 14:59, 11 December 2018
DIFFERENCE(GivenSet1,GivenSet2)
- where are the arrays for which difference is to be found.
are the arrays for which difference is to be found.Description
- This function computes the difference of the two arrays.
- Function compares GivenSet1 array against GivenSet2 array and returns the values in GivenSet1 that are not present in the other array.
- DIFFERENCE function will consider text, numbers, or any special characters like @,&...
- Input other than numbers should be given in quotes.
Examples
- DIFFERENCE([1,2,3,4,5,0],[5,6,7,1,"a",8]) = 2 3 4 0
- DIFFERENCE(["@","&","*"],["@","&","*"]) =
- DIFFERENCE([1,2,3,"a","@","&","*"],["@","&","*"]) = 1 2 3 a
Related Videos