# SQL Sequence Ceil, Floor Functions

> The `seq_ceil()` and `seq_floor()` functions take sequence arguments of type double and return a sequence of type double containing the values of the nearest integer below or above the input element value.

> Following is an example script demonstrating the `seq_ceil()`and `seq_floor()` functions:

>         INSERT INTO SimpleSequence(testNumber,dVal1)
>         VALUES(4,'{2.9,3.14,4.6}');

>         SELECT dVal1, seq_ceil(dVal1) AS "ceil" FROM SimpleSequence WHERE testNumber = 4;
>         SELECT dVal1, seq_floor(dVal1) AS "floor" FROM SimpleSequence WHERE testNumber = 4;

>         dVal1{}
>         ceil{}
>         ---------------------------------------------------------------
>         {2.900000, 3.140000, 4.600000}
>         {3.000000, 4.000000, 5.000000}

>         dVal1{}
>         floor{}
>         ---------------------------------------------------------------
>         {2.900000, 3.140000, 4.600000}
>         {2.000000, 3.000000, 4.000000}

> #### So the result values for this dataset are obtained as follows:

> value | ceil | floor
> --- | --- | ---
> 2.90 | 3.00 | 2.00
> 3.14 | 4.00 | 3.00
> 4.60 | 5.00 | 4.00

> ## 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