How to change the multiple Row into 1 row

Question

Question

Steven Henry Su... · Jun 5

#SQL #Other #TrakCare

Hy Friends,

I have a question, how to change multiple rows into 1 row

This data already in the right order, but I need to change the Diagnose into 1 column with this order 1,2,3,4

So it should be Acute...,Fever..., Dyspepsia, Dengue fever

Does anyone could help me ?

Thank You

Best Regards,

Steven Henry

Product version: IRIS 2023.3

Discussion (8)2

Log in or sign up to continue

score 0 · Answer 1 · 2024-06-05T07:04:30-04:00

Heloisa Paiva · Jun 5

you can pivot your table and concatenate the results or union join them

0 0

score 1 · Answer 2 · 2024-06-05T07:33:22-04:00

Wrap your SELECT in an Outer SELECT LIST(...inner select ...)
try:

SELECT LIST(DIAGNOSE) FROM (
 SELECT MRDIA_.....->MRCID....
 FROM ......
 WHERE .....
 ORDER BY ......
)

score 1 · Answer 3 · 2024-06-05T07:50:48-04:00

Chris Stewart · Jun 5

Robert beat me to it, this was my suggestion too

1 0

score 0 · Answer 4 · 2024-06-05T22:34:11-04:00

Hy @Chris Stewart it doesn't work my friend, it because of order by

I got an Info that Order by cannot used as Sub Query

score 0 · Answer 5 · 2024-06-05T22:33:02-04:00

nice but it doesnt work, because of Order by, I've try and it give an Error but if I comment Order By, it works, but not what I want

score 2 · Answer 6 · 2024-06-06T02:25:59-04:00

SELECT LIST(Diagnose) FROM
(SELECT TOP ALL MRDIA_ICDCode_DR->MRCID_Desc Diagnose
FROM SQLUser.MR_Diagnos
WHERE MRDIA_MRADM_ParRef=123456789
ORDER BY MRDIA_DiagnosisType_DR ASC)

score 0 · Answer 7 · 2024-06-06T02:56:05-04:00

Steven Henry Su... · Jun 6

Yes, It Works !!! Thank You Very Much @Vitaliy Serdtsev

0 0

score 0 · Answer 8 · 2024-06-06T03:24:19-04:00

Luc Morningstar · Jun 6

correct typing of latin characters is a very useful skill.

0 0