Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can we put where condition while fetching data from QVDs?
Is it possible?
Load
...
from ....
Where ....;
let me know
Hi possible.
look at below code
Dept:
LOAD empid,
deptname
FROM
dept.qvd
(qvd) where deptname = 103 ;
Regards
ASHFAQ
Try like this:
Dept:
LOAD empid,
empname,
salary,
deptname
FROM
dept.qvd
(qvd) where Salary > = 30000 ;
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;