Thanks Igor, I haven't note about the diagram, now I want to ask you
help for this:
CASE
WHEN field1 IS NULL
THEN 'SIN CERRAR'
ELSE (STRFTIME('%J',field1) - STRFTIME('%J',field2))
END AS DIAS_CERRAR,
Igor Tandetnik escribió:
> Carlos Suarez <carlos.sua...@rolsoft.com>
> wrote:
>
>> Hello, my name is Carlos I need to replace de common sentence in
>> hsqldb --LIMIT min rows - max rows with something for delimit a query
>> in sqlite because this is not supported
>>
>
> select * from mytable
> limit 10 offset 5;
>
> -- or
>
> select * from mytable
> limit 5, 10;
>
> For more details, see http://sqlite.org/lang_select.html
>
> Igor Tandetnik
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
