Where condition while fetching data from Qvds

[rsdhavle]

Hi,

How can we put where condition while fetching data from QVDs?

Is it possible?

[alexandros17 · Accepted solution]

Load

...

from ....

Where ....;

let me know

[ashfaq_haseeb]

Hi possible.

look at below code

Dept:

LOAD empid,

     deptname

FROM

dept.qvd

(qvd) where deptname = 103 ;

Regards

ASHFAQ

[Anonymous]

Try like this:

Dept:

LOAD empid,

          empname,

          salary,

     deptname

FROM

dept.qvd

(qvd) where Salary > = 30000 ;

[its_anandrjs]

Yes you may and there are many ways for that depends on the condition that you have

Ex:-

Load

CommonDate,

Name,

Country

From QVD

Where  CommonDate = Today();

Or

Load

CommonDate,

Name,

Country

From QVD

Where  Rowno() > 50;