__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
SQL Language Extension: LIST
Function:
This function returns a string result with the concatenated non-NULL
values from a group. It returns NULL if there are no non-NULL values.
Authors:
Oleg Loa <loa@mail.ru>
Dmitry Yemanov <dimitr@firebird.org>
Format:
<list function> ::=
LIST '(' [ {ALL | DISTINCT} ] <value expression> [',' <delimiter value> ] ')'
<delimiter value> ::=
{ <string literal> | <parameter> | <variable> }
Syntax Rules:
1) If neither ALL nor DISTINCT is specified, ALL is implied.
2) If <delimiter value> is omitted, a comma is used to separate
the concatenated values.
Notes:
1) Numeric and datetime values are implicitly converted to strings
during evaluation.
2) The result value is of type BLOB with SUB_TYPE TEXT for all cases
except list of BLOB with different subtype.
3) Ordering of values within a group is implementation-defined.
Examples:
A)
SELECT LIST(ID, ':')
FROM MY_TABLE
B)
SELECT TAG_TYPE, LIST(TAG_VALUE)
FROM TAGS
GROUP BY TAG_TYPE