[DERBY-2887] NULLS FIRST / LAST for ORDER BY

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 10.4.1.3
• Component/s: SQL
• Assignee: Bryan Pendleton
• Reporter: Christian d'Heureuse
• Created: 30/Jun/07 20:45
• Updated: 21/Jan/11 17:50
• Resolved: 26/Sep/07 04:51

Description

I suggest to implement the "null ordering" option for the "ORDER BY" clause:

According to the SQL standard, 10.10 <sort specification list>:

<null ordering> ::=
NULLS FIRST

NULLS LAST

Issue Links

• is duplicated by: DERBY-2965 Add support for NULLS FIRST / NULLS LAST on ORDER BY clause
• relates to: DERBY-4382 missing documentation from reference guide for ORDER BY null ordering clause (i.e. NULLS FIRST / NULLS LAST )
• relates to: DERBY-581 Modify SQL to skip N rows of the result and return the next M rows