TOP N rows from QVD

[chiru_thota]

Hi All,

I need to get first 10 rows from a QVD  into QVW irrespective of data.

Is there any way we can do that ?

Thanks,

Chiru

[Clever_Anjos · Accepted solution]

FIRST 10

LOAD

*

FROM QVD.qvd(qvd)

[luis_pimentel]

Something like this should work:

FIRST 10

LOAD

*

FROM yourdata.qvd (qvd);

or

LOAD

     *

FROM

     yourdata.qvd (qvd)

WHERE

     RowNo() <= 10;