# SQL Sequence Unique Function

> The `seq_unique()` function removes repeating values from the result sequence but a value may appear more than once. For example, note that the value 4 in the result set above appears once at the beginning of the sequence where the input sequence has a repeated value, and then again at the second to last element where the single value of 4 is present in the input sequence.

> Following is an example script demonstrating the `seq_unique()` function:

>         INSERT INTO SimpleSequence(testNumber,iVal1)
>         VALUES(3,'{4,4,7,7,7,5,4,3}');

>         SELECT iVal1, seq_unique(iVal1) AS "unique" FROM SimpleSequence WHERE testNumber = 3;

>         iVal1{}
>         unique{}
>         ----------------------------------------------------------------------
>         {4, 4, 7, 7, 7, 5, 4, 3}
>         {4, 7, 5, 4, 3}

> ## Sample script

> A sample script to demonstrate this `select` statement using xSQL can be run from the `samples/xsql/scripts/financial` directory with the following command:

>         f 2