On 02/06/2014 10:00 AM, Rémi Cura wrote: > Hey, > I don"t understand the difference between this ORDINALITY option and > adding a "row_number() over()" in the SELECT.
WITH ORDINALITY will give you something to order by. You should never do "row_number() over ()" because that will give you potentially random results. -- Vik