Hi,
> I think I need at least an order by count or indul_ido. Where do I have to
> put it?
I found the answer: at the end of the statement. ;-)
> Other problem is these two records:
> 23;"5501289";"Győr";1;"07:41:00";"07:41:00";"910_23"
> 28;"5544800";"Csorna";1;"08:00:00";"08:00:00";"910_28"
>
> It is correct we eliminated the double record but it is not enough!
After order by count I found my previous sentence wasn't true!
So we have to focus to this problem:
22;"5501289";"Győr";1;"07:39:00";"07:39:00";"910_22"
23;"5501289";"Győr";1;"07:41:00";"07:41:00";"910_23"
28;"5544800";"Csorna";1;"08:00:00";"08:00:00";"910_28"
29;"5544800";"Csorna";1;"08:12:00";"08:12:00";"910_29"
Now I revised the result records. I don't want to change the
train_selector except the duplicated records. I think you
misunderstood my task. Train_selector has to be modified
because the duplicated record will be merged in only one
record and the original train_selector related to the original
records.
TIA,
Ruzsi