[jira] [Commented] (TRAFODION-2088) support null last and null first in ORDER BY

[liu ming (JIRA)]

    [ 
https://issues.apache.org/jira/browse/TRAFODION-2088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16365242#comment-16365242
 ] 

liu ming commented on TRAFODION-2088:
-------------------------------------

see 
[https://stackoverflow.com/questions/1456653/sql-server-equivalent-to-oracles-nulls-first]

 
 * DESC + NULLS FIRST:

{{ORDER BY (CASE WHEN [Order] IS NULL THEN 0 ELSE 1 END), [Order] DESC}}

 * ASC + NULLS LAST:

{{ORDER BY (CASE WHEN [Order] IS NULL THEN 1 ELSE 0 END), [Order] ASC}}

 * ASC + NULLS FIRST: it works fine by default

 * DESC + NULLS LAST: it works fine by default

 *

> support null last and null first in ORDER BY
> --------------------------------------------
>
>                 Key: TRAFODION-2088
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2088
>             Project: Apache Trafodion
>          Issue Type: Improvement
>            Reporter: liu ming
>            Assignee: liu ming
>            Priority: Minor
>
> handle the syntax ‘order by nulls last’



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)