Pop-Up Thingie
Sidebar
>>> Magnum BBS <<<
Home
Forum
Files
Dark
Log in
Username
Password
Sidebar
Forum
Usenet
COMP.DATABASES.INFORMIX
Sql to concatenate multiple rows to a single row / column
From
vignesh K
@21:1/5 to
All
on Fri Jul 8 04:45:42 2022
Is there a way of concatenating the results from one column / multiple
rows into a one column / one row?
Problem:
I have a Grade table with following columns
grade_id
grade_val
grade_id grade_val
=================
1 25
2 45
3 63
How can i write a query to generate the following result
grade_val
25,45,63
I'm used listagg,group_concat but it raised error on
Sql Error -674: Routine (listagg) can not be resolved.
Any help would be greatly appreciated.
Thanks !
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
Who's Online
Recent Visitors
Foxagg
Fri Mar 29 04:40:39 2024
from
The Void, Nowhere
via
SSH
Foxagg
Fri Mar 29 03:27:44 2024
from
The Void, Nowhere
via
SSH
Keyop
Fri Mar 29 03:27:35 2024
from
Huddersfield, West Yorkshire
via
SSH
Keyop
Fri Mar 29 02:55:21 2024
from
Huddersfield, West Yorkshire
via
SSH
System Info
Sysop:
Keyop
Location:
Huddersfield, West Yorkshire, UK
Users:
286
Nodes:
16 (
2
/
14
)
Uptime:
83:06:21
Calls:
6,495
Calls today:
6
Files:
12,096
Messages:
5,276,829