NULLS FIRST / NULLS LAST modifier, supported by most (not all) dialects.
NULLS FIRST
NULLS LAST
Companion enum NullsOrder is available for the 'FIRST' | 'LAST' string-literal union below; raw string literals continue to work unchanged.
'FIRST' | 'LAST'
// Using raw string literals (still supported)rowNumber().orderBy('salary', 'DESC', 'LAST')// Using the NullsOrder enumimport { NullsOrder } from './query-builders/functions/window';rowNumber().orderBy('salary', 'DESC', NullsOrder.LAST) Copy
// Using raw string literals (still supported)rowNumber().orderBy('salary', 'DESC', 'LAST')// Using the NullsOrder enumimport { NullsOrder } from './query-builders/functions/window';rowNumber().orderBy('salary', 'DESC', NullsOrder.LAST)
NULLS FIRST/NULLS LASTmodifier, supported by most (not all) dialects.Companion enum NullsOrder is available for the
'FIRST' | 'LAST'string-literal union below; raw string literals continue to work unchanged.Example