python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - string-agg

How do i use STRING_AGG and avoid duplicate values?

I face the following problem: in a SQL table i have stored Information about persons, date and diseases. CREATE TABLE Diseases (person varchar(80), time date, disease varchar(80)) INSERT INTO Disease...
test-img

Philipp Schulz

sql

hana

string-agg

Votes: 0

Answers: 1

Latest Answer

The requirement is not fully clear and leaves room for interpretation. Still let me take a stab to answer, what I think you've asked. You can easily enhance your select statement with a where clause t...
test-img

Mathias Kemeter

Posts

Questions

Blogs

Jobs