[
https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16908059#comment-16908059
]
Rick Hillegas commented on DERBY-7051:
--
Glad to hear it! Closing this issue.
> Multiple DISTINCT
[
https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16907714#comment-16907714
]
JackLi0812 commented on DERBY-7051:
---
{code:java}
SELECT DISTINCT
(SELECT COUNT(ORDERS.CUSTOMER_ID)
[
https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16907241#comment-16907241
]
Rick Hillegas commented on DERBY-7051:
--
Try this:
{noformat}
connect
[
https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16906883#comment-16906883
]
JackLi0812 commented on DERBY-7051:
---
oh, no, i need a query sql.
> Multiple DISTINCT columns are not
[
https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16906793#comment-16906793
]
Rick Hillegas commented on DERBY-7051:
--
Try this:
{noformat}
connect
[
https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16906776#comment-16906776
]
JackLi0812 commented on DERBY-7051:
---
Hi, Rick:
Let's say I have a table with a purchase history
[
https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16906182#comment-16906182
]
Rick Hillegas commented on DERBY-7051:
--
That is non-Standard syntax. The (DISTINCT) must appear