Getting first n records in QVD

[deepakqlikview_123]

Hi All,

My database table size is too big,moreover it does not have index number.

Can you please suggest how to get first n records while creating QVD please suggest.

Thanks,

Deepak

[SunilChauhan]

Load *

from table name where Rowno()<100;

[avinashelite · Accepted solution]

Hi Deepak,

At the script try like below:

First 100000 load * from tablename;

This will fetch you the first n records from the DB, then u can make the analysis.

Regards,

@vi