[英] Select rows with same id but different value in another column
我试了几个小时,读了很多帖子,但我仍然不知道如何处理这个请求:
我有一张这样的桌子:
+------+------+
|ARIDNR|LIEFNR|
+------+------+
|1 |A |
+------+------+
|2 |A |
+------+------+
|3 |A |
+------+------+
|1 |B |
+------+------+
|2 |B |
+------+------+
我想选择使用不同LIEFNR多次出现的ARIDNR.
输出应该类似于:
+------+------+
|ARIDNR|LIEFNR|
+------+------+
|1 |A |
+------+------+
|1 |B |
+------+------+
|2 |A |
+------+------+
|2 |B |
+------+------+