A .isect()

Read(202) Label: sequence, intersection,

Description:

Compute the intersection of all sequence-type members in a sequence.

Syntax:

A.isect()

Note:

Members of sequence A are also sequences. The function creates a new sequence composed of all common members of the sub-sequences.

Parameters:

A

A sequence whose members are also sequences.

Return value:

A sequence

Example:

 

A

 

1

=[[1,2,3,4,5],[3,7,8]].isect()

[3]

2

=[[1,2,3],[3,2]].isect()

[2,3]

3

=[[1,2,2,3],2].isect()

[2]

4

=demo.query("select top 2 * from EMPLOYEE")

5

=demo.query("select top 1 * from EMPLOYEE")

6

=[A4,A5].isect()

[] Since A4 and A5 come from different table sequences and have different store addresses, so same records are regarded as different members

Related functions:

A.union()

A.diff()

A.conj()

A.xunion()