如何获得两个不同的列值？

我有三列名为CustomerID int，PurchaseID int，PaymentDate datetime。



每个CustomerID可以有多个PurchaseID，付款将每天多次完成。

我的表数据如下所示：

[C_ID P_ID P_Date]

[c1 p1 01/01/2017]

[c2 p2 01/01/2017]

[c2 p2 01/01/2017]

[c2 p2 02/01/2017]

[c2 p3 02/02/2017]

[c3 p4 10/10/2017]



我是试图显示不同的日期和不同的P_ID。

例如对于CustomerID c2：仅显示

[c2 p2 01/01/2017]

[c2 p2 02/01/2017]

[c2 p3 02/02/2017]

这些结果列于结果表中。



你能不能帮我这个。

谢谢。



我尝试了什么：



选择不同的（C_ID），*来自我的表



但它没有给出预期的结果。

I have three columns named as CustomerID int, PurchaseID int, PaymentDate datetime.

each CustomerID can have multiple PurchaseIDs and Payment will be done multiple times a day.
my table data looks like as below:
[C_ID P_ID P_Date]
[c1 p1 01/01/2017]
[c2 p2 01/01/2017]
[c2 p2 01/01/2017]
[c2 p2 02/01/2017]
[c2 p3 02/02/2017]
[c3 p4 10/10/2017]

I'm trying to display distinct dates and distinct P_IDs.
for example for CustomerID c2: Display only
[c2 p2 01/01/2017]
[c2 p2 02/01/2017]
[c2 p3 02/02/2017]
these results in result table.

Could you please help me with this.
Thank you.

What I have tried:

select distinct(C_ID), * from mytable

but it doesn't gives the expected results.