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