How to group two lines with the same ID but different values

Question

hi friends As you see I have the same Num_attachement but two lines me I want to display just one line but with the values ​​of the rows that are different thanks in advance

ma ouml · Answer

Rajkiran Swain I saw this site but I did not understand how I practice the request for my case More reason I want to display the same ID for example 'AT / 1415' but the other columns will be different

Rajkiran Swain · Answer

https://stackoverflow.com/questions/21162812/select-rows-with-same-id-but-different-value-in-another-column

ma ouml · Answer

Sundar The 'marche.Num_marche' column is not valid in the HAVING clause because it is not contained in an aggregate function or in the GROUP BY clause.

Sundar · Answer

Else you can flow this code. Change as per your requirements SELECT StudentID, CourseNames=STUFF ( ( SELECT DISTINCT ', '+ CAST(g.CourseName AS VARCHAR(MAX)) FROM Courses g,StudentCourses e WHERE g.CourseID=e.CourseID and e.StudentID=t1.StudentID FOR XMl PATH('') ),1,1,'' ) FROM StudentCourses t1 GROUP BY StudentID

Sundar · Answer

could you translate the Error in English and paste.

ma ouml · Answer

Sundar it shows me this error

Sundar · Answer

Your SQL ============== select at_m.Num_attachement, at_m.Date_debut,at_m.Date)fin,at_m.Montant,at_m.Flag_dernire from attachment_marche at_m where at_m.Id_marchae in (select Id_marche from marche where Num_marche='02/TC3PC/2014') As per Manikandan Shared Code your SQL Code Will be ============================== =============== select at_m.Num_attachement, at_m.Date_debut,at_m.Date)fin,at_m.Montant,at_m.Flag_dernire from attachment_marche at_m where at_m.Id_marchae in (select Id_marche from marche GROUP BY Id_marche HAVING Num_marche='02/TC3PC/2014') Thanksin Advance

ma ouml · Answer

Manikandan Murugesan You can explain to me according to the request that I published

Manikandan Murugesan · Answer

The idea is to use the inner query to identify the records which have a ARIDNR value that occurs 1+ times in the data, then get all columns from the same table based on that set of values. SELECT * FROM YourTable WHERE ARIDNR IN ( SELECT ARIDNR FROM YourTable GROUP BY ARIDNR HAVING COUNT (*) > 1 )

How to group two lines with the same ID but different values

Answers (9)