mysql中distinct删除_MySQL distinct查询返回具有重复信息的行，需要重复数据删除

我有一个类似于MySQL数据库中下面显示的表格：

+----------+----------+----------+----------+----------+

| Column_A | Column_B | Column_C | Column_D | Column_E |

+----------+----------+----------+----------+----------+

| 1 | 11 | a | 0 | abc |

| 2 | 22 | a | 0 | abc |

| 3 | 33 | a | 0 | def |

| 4 | 44 | b | 0 | def |

| 5 | | b | 0 | def |

| 6 | 55 | c | 0 | ghi |

| 7 | | d | 0 | jkl |

| 8 | | a | 4 | abc |

| 9 | | a | 4 | abc |

| 10 | | b | 4 | abc |

| 11 | 88 | f | 4 | xyz |

| 12 | | f | 4 | xyz |

+----------+----------+----------+----------+----------+我需要一个类似于下面的结果(即只有a& b值具有不同的D& E列值)：

+----------+----------+----------+

| Column_C | Column_D | Column_E |

+----------+----------+----------+

| a | 0 | abc |

| a | 0 | def |

| a | 4 | abc |

| b | 0 | def |

| b | 4 | abc |

+----------+----------+----------+我试过这个查询：

SELECT DISTINCT column_c,column_d,column_e FROM trial2 ORDER BY column_c;我得到这个：

+------------------+------------------+------------------+

| column_c | column_d | column_e |

+------------------+------------------+------------------+

| a | 0 | abc |

| a | 0 | def |

| a | 4 | abc |

| b | 0 | def |

| b | 4 | abc |

| c | 0 | ghi |

| d | 0 | jkl |

| f | 4 | xyz |

+------------------+------------------+------------------+我不需要column_c中'c'，'d'或'f'的行。我需要既有0&在column_d中有4个值(即column_c是'a'或'b')。