如何获得两个不同的列值？ [英] How do I get two distinct column values ?

问题描述

我有三列名为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.

推荐答案

SELECT DISTINCT C_ID, P_ID, P_Date FROM mytable

或

or

SELECT C_ID, P_ID, P_Date FROM mytable
GROUP BY C_ID, P_ID, P_Date

其中任何一个都应该有效。

Any of these should work.

这篇关于如何获得两个不同的列值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！