I am fetching data from Qvd with max number combined key. Numbers are 0,1,2,3,4,5,6 present in number field. But it showing only 1,2,3,4,5 numbers data. Following is the sample script. Thanks in Advance.
Distinct POL_NO&max(ENDOR_NUM) as polKey1%,
max(ENDOR_NUM) as ENDOR_NUM_MAX
(qvd) Group by POL_NO;
Distinct POL_NO&ENDOR_NUM as polKey1%,