
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Try This Script in Qlikview u get 100 rows
First (100) Select * from IE order by jobno desc;
Regards
Perumal

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
