Question Krishnaveni Kapu · Sep 11, 2024

SQL query to get multiple records

I have an SQL table as below (columns - ID and Value)

I will get an ID number (first column) as an input from FTP inbound , and after that I have to query table taking ID as an input to get all the values for the ID 

as -

if ID = 11 ; QRY output = aaa,bbb

if ID = 22 ; QRY output =  xxx,yyy,zzz

can someone help me with query 

ID    Value
----------
11    aaa
22    xxx
22    yyy
11    bbb
22    zzz
-----------
 

Comments

Robert Cemper · Sep 11, 2024

ÍD is an reserved name in IRIS / Ensemble
in fact as you describe it, it is rather a KEY than a typical ID
so this query may serve your needs

SELECT LIST(Value) WHERE KEY=11 

SELECT LIST(Value) WHERE KEY=12

0