A query assigns ROW_NUMBER() using an ORDER BY column that has ties. The application requires stable ordering between tied rows. What should be added?

Published
  1. A suitable unique tie-breaker to the ordering
  2. A smaller font in the report
  3. Assume all ties are always returned identically without a defined rule
  4. A longer column alias

Comments — 0