Reverse Order by

Hi all -

I was blown away by what a FB user posted in the Ninox English forum. I don't remember seeing this any where else.

To do a reverse order by you can just put a "-" in front of the field name you use.


I thought it was a typo. Then I tried it and:


I'm going to go and recover for bit.

3 replies

    • netSME_Sylvain_Moesching
    • 11 mths ago
    • Reported - view

    it works with date also , as it is treated as numbers

    select table order by -date   

    would give you the most recent dates first

      • Fred
      • 11 mths ago
      • Reported - view

      netSME_Sylvain Moesching Thanks for the update. I was trying to find your account in this forum but nothing came up with just your name.

    • Ninox developper
    • Jacques_TUR
    • 11 mths ago
    • Reported - view

    Hello friends, you can find more information on the reverse order for the number and text here. : https://forum.ninox.com/t/p8hrzqj?r=h7hraxw

Content aside

  • 11 mths agoLast active
  • 3Replies
  • 182Views
  • 3 Following