Home > database >  How do you use the group by group, after having further screening?
How do you use the group by group, after having further screening?

Time:01-02



Has been in use for group by t.z yh, t.f ymc grouping,
Then having a count (t.z yh) & gt; 1 selected t.z yh is greater than 1 time to show, but the result is a display only one t.z yh,

Big brand!

CodePudding user response:

Try this
Having a count (distinct t.f ymc) & gt; 1

CodePudding user response:

reference 1st floor selling fruit net reply:
try this
Having a count (distinct t.f ymc) & gt; 1

Tried, after added diatinct, a data all have no, this principle should be normal, to weight each group is only a data, that is greater than 1 should be no data

CodePudding user response:

The source data look like? The original poster about cut a figure,
  • Related