db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yip Ng (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.
Date Wed, 21 Feb 2007 00:32:05 GMT

    [ 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.


Mime
View raw message