How can I get one row from two rows or more in SQL query?

For example I have table:

Table

ID Let

1 ab

1 cd

2 fd

2 ld

I wish to get

ID Let

1 ab, cd

2 fd, ld

---

Nensy V.

//Try this sample Code:

CREATE

TABLE TestTable (

acc_nbr

INT,

CName

VARCHAR(20),

DecNames

VARCHAR(20),

PRIMARY

KEY (acc_nbr,DecNames));

INSERT

INTO TestTable VALUES (1234, 'SUDHIR', '20080101');

INSERT

INTO TestTable VALUES (1234, 'PRASHAT', '20081002');

INSERT

INTO TestTable VALUES (1234, 'YOGESH', '20081003');

SELECT

acc_nbr,(SELECT DecNames+',' FROM TestTable t Where t.acc_nbr = o.acc_nbr for xml path('') ) as Types_Combined

from

TestTable o

---

Please mark the post as answer if it is helpfull to you because it boosts the members to answer more and more.

It's works!

You only have to put DISTINCT to get one row.

So select query would look like:

SELECT DISTINCT
acc_nbr,(SELECT DecNames+',' FROM TestTable t Where t.acc_nbr = o.acc_nbr for xml path('') ) as Types_Combined
from TestTable o

Thanks!

---

Nensy V.

//Try this sample Code:

CREATE

TABLE TestTable (

acc_nbr

INT,

CName

VARCHAR(20),

DecNames

VARCHAR(20),

PRIMARY

KEY (acc_nbr,DecNames));

INSERT

INTO TestTable VALUES (1234, 'SUDHIR', '20080101');

INSERT

INTO TestTable VALUES (1234, 'PRASHAT', '20081002');

INSERT

INTO TestTable VALUES (1234, 'YOGESH', '20081003');

SELECT

acc_nbr,(SELECT DecNames+',' FROM TestTable t Where t.acc_nbr = o.acc_nbr for xml path('') ) as Types_Combined

from

TestTable o

---

Please mark the post as answer if it is helpfull to you because it boosts the members to answer more and more.

It's works!

You only have to put DISTINCT to get one row.

So select query would look like:

SELECT DISTINCT
acc_nbr,(SELECT DecNames+',' FROM TestTable t Where t.acc_nbr = o.acc_nbr for xml path('') ) as Types_Combined
from TestTable o

Thanks!

---

Nensy V.