阅读背景:

Firebird 2.5——SQL中的等价函数(GROUP_CONCAT在MySql中/ LISTAGG在Oracle中)

来源:互联网 

Does anyone know if Firebird 2.5 has a function similar to the "STUFF" function in SQL? I have a table which contains parent user records, and another table which contains child user records related to the parent. I'd like to be able to pull a comma delimited string of the "ROLES" the user has without having to use a second query, loop over the values returned for the given ID and create the string myself.Does anyone know if Firebird 2.5 has a function




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: