[
https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12474620
]
Yip Ng commented on DERBY-264:
------------------------------
Hi Laura:
I think the following statement can be separated out from the "expression"
description and moved it before the Example section since it applies to
column-name as well.
"If SELECT DISTINCT is specified or if the SELECT statement contains a GROUP BY
clause, the ORDER BY columns must be in the SELECT list."
For the examples, perhaps the following may suffice?
You can sort the result set by a numeric expression, for example:
SELECT name, salary, bonus FROM employee ORDER BY salary+bonus
where salary and bonus are of decimal type.
You can sort the result set by invoking a function, for example:
SELECT i, len FROM measures ORDER BY sin(i)
> This enhancement to allow expressions in ORDER BY clause will require
> documentation changes.
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-264
> URL: https://issues.apache.org/jira/browse/DERBY-264
> Project: Derby
> Issue Type: Sub-task
> Components: Documentation
> Affects Versions: 10.1.1.0, 10.2.1.6
> Reporter: Satheesh Bandaram
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: derby264_1.diff, rrefsqlj13658.html, rrefsqlj19433.html
>
>
> I can help if needed for documenting this enhancement.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
