mardi 5 mai 2015

Duplications in Query Result

I am working on SQL Server to organize the generated data in C#. However, when I check the data in the table, there is a problem.

Here is the sample results:

Title                           Author Names                      with  w/o
Estimating the usefulness ...   W Meng KL Liu C Yu W Wu N Rishe     71  64

Estimating the usefulness ...   W Meng KL Liu C Yu W Wu N Rishe     71  58

Estimating the usefulness ...   W Meng KL Liu C Yu W Wu N Rishe     71  54

Estimating the usefulness ...   W Meng KL Liu C Yu W Wu N Rishe     71  53

The effect of negation ...      L Jia  C Yu   W Meng                66  65

The effect of negation ...      L Jia  C Yu   W Meng                66  65

The effect of negation ...      L Jia  C Yu   W Meng                66  65

The effect of negation ...      L Jia  C Yu   W Meng                66  65

What kind of query should I write to get this result:

Estimating the usefulness ...   W Meng KL Liu C Yu W Wu N Rishe     71  53

The effect of negation ...      L Jia  C Yu   W Meng                66  65

Thank you for your time and help.

Note: Distinct does not work for this.

Aucun commentaire:

Enregistrer un commentaire