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?