Fetch the limited data in Tables

[Kohli]

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

[mrybalko]

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.

[sirivikram1506]

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