Viewing 3 posts - 1 through 4 (of 4 total)
But, this is not my objective as said in Message 4.
We would like to keep only the record that contain the first occurrence of ARM and BESTRES in each value.
After...
January 23, 2007 at 4:27 am
Dear all,
RLoski response work similar to my method. In order to distinguish two 01, I put the original query as a temp table x and select distinct * of it....
January 23, 2007 at 4:22 am
Hello Russel and Sergiy,
Thank you for your suggestion but both queries got a diffrent result from mine.
Let me change the objective a little bit
To visualize, this is input: