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.

- netSME_Sylvain_Moesching
- 1 yr 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
  
  1 yr 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
- 1 yr 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