Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Iam using my sql database. It has lot of data. I need to fetch the only from 01-02-2019 on wards. How can i do it
You should limit data in SQL SELECT by WHERE or LIMIT
SELECT * FROM tbl_foo WHERE name = 'sarmen' LIMIT 1
You can use Qlik keyword "First" but it is executed after SQL.
Hi Kohli,
Floow below procedure to restrict the data at script level.
Load/Select col1,col2,clo3,clo4,col.......n from table
where Date>='01-02-2019 ' ;
i hope it helps you.
Regards,
Vikram