2 Replies Latest reply: Mar 7, 2012 6:06 AM by jagan mohan rao appala RSS

    Last 1000 entries (SQL ... order by ID desc ...limit 1000)

      Hi Everybody,


      it is possible to get only the last 1000 entries?

      In QV I just found the function FIRST (FIRST 1000 entries).

      For testing for me is fine when I get my last 1000 entries.


      In SQL:


      select ID, Name, Store from mytable

      order by ID desc

      limit 1000


      Thx in advance