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

[#1]

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

[perumal_41]

Hi

Try This Script in Qlikview u get 100 rows

First (100) Select * from IE order by jobno desc;

Regards

Perumal 

[jagan]

Hi,

There is no such option to retrieve last n number of rows.  There is only option for first n number of rows.  To retrieve last rows then you need to use order by desc.

//Loads last 10 records

First (10)

Select * from Orders

order by ID DESC; (Note: The parenthesis is allowed but not required.)

//Loads first 10 records

First 10

Load * from abc.csv; 

Hope this helps you.

Regards,

jagan.