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