[jira] [Commented] (DERBY-7051) Multiple DISTINCT columns are not supported

[ 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

[jira] [Commented] (DERBY-7051) Multiple DISTINCT columns are not supported

[ 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

[jira] [Commented] (DERBY-7051) Multiple DISTINCT columns are not supported

[ 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

[jira] [Commented] (DERBY-7051) Multiple DISTINCT columns are not supported

[ 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

[jira] [Updated] (DERBY-7051) Multiple DISTINCT columns are not supported

[ https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JackLi0812 updated DERBY-7051: -- Description:   {code:java} SELECT DISTINCT (ORDERS.CUSTOMER_ID), DISTINCT (ORDERS.ORDER_ID) FROM

[jira] [Created] (DERBY-7051) Multiple DISTINCT columns are not supported

JackLi0812 created DERBY-7051: - Summary: Multiple DISTINCT columns are not supported Key: DERBY-7051 URL: https://issues.apache.org/jira/browse/DERBY-7051 Project: Derby Issue Type: Bug