Pulling 100 records from database having 1000000

[#1]

Hi All,

Please any one help me to get the 100 records from  100000 records,

can we use the same Query in Qlikview ( select * from STG_EDW_ORD_DTL where rownum<=1000; )

thanks in advance,

Ram.

[Miguel_Angel_Baeyens]

Hi Ram,

Indeed, you can do it in several ways:

Table:
LOAD *
FROM File.qvd (qvd)
WHERE RecNo() <= 100; // depending on your script, you can also use RowNo()

or

Table:
FIRST 100 LOAD *
FROM File.qvd (qvd);

Hope that helps.

Miguel

[VishalWaghole]

Hi Ram,

         Yes u can use query like

select * from STG_EDW_ORD_DTL where rownum<=100;

or

make qvd file for this table like

STG_EDW_ORD_DTL:

select * from STG_EDW_ORD_DTL where rownum<=100;

store STG_EDW_ORD_DTL into ../Qvds/STG_EDW_ORD_DTL.qvd;

Drop table STG_EDW_ORD_DTL;

and use this qvd file as ur table like

TABLE:

LoAD  *

FROM  STG_EDW_ORD_DTL.qvd(qvd)

Where RecNo() <= 100;

Thanks