2 Replies Latest reply: May 31, 2012 6:25 PM by Rob Wunderlich RSS

    problem with using previous and order by resident table

    Jack Zheng

      I just discovered something interesting.  Please see attached file for reference.


      When I tried to do a order by in the same table as I am doing the previous, it breaks (new_table1).  I had to create a new sort table, sort the data first, and then de-dupe the data (new_table4).


      new_table1 shows that it doesn't work while new_table4 does work after I do a sort_table first.


      Why is that?


      Also, since I have to do 2 table loads using the previous function, which will be faster?  Using distinct or use the 2 tables and the previous function?