AAA field BBB CCC field DDD
1 TEST 8 0
2 the TEST 1 1
3 TEST 2 0
3 TEST 2 0
3 TEST 2 0
4 the TEST 2 1
4 the TEST 2 1

Need to get the requirement of

Field A=3,
All field data of AAA=3, field CCC some data in the field in the AAA, in meet the previous data, to find some data in the field. A field D, the results are as follows
AAA field BBB CCC field DDD
1 TEST 8 0
2 the TEST 1 1
3 TEST 2 0
3 TEST 2 0
3 TEST 2 0
That is the first article is not eligible,
Article 3 AAA=3 above, meet the conditions of 2, is the second article, satisfy the condition 3 is the first

CodePudding user response:

The building Lord baidu once connect by the usage,