Tuesday, April 10, 2012
Sybase IQ equavalent for Oracle wm_concat and SQL group_concat
Sybase IQ equavalent for Oracle wm_concat and SQL group_concat is LIST() function.
This function takes 2 parameters column_name (mandotory) and separator (optional default ",").
Sample query:
select list(table_name) from systable
Click for related Sybase Central entry
0 comments:
Post a Comment