_num
FROM price_old ) t
WHERE t.my_row_num > 1 );
On Sun, Mar 13, 2022 at 10:52 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Sun, Mar 13, 2022 at 7:44 AM Roger Bos wrote:
>
>> WITH cte AS
>> ( SELECT *, ROW_NUMBER() OVER ( PARTITION BY
Hello, trying to use CTE to remove duplicates from a table. The DELETE
version does not work, but the SELECT version does, so I am not
understanding what the problem is. Any suggestions on how to fix it?
Here is my query:
WITH cte AS
( SELECT *, ROW_NUMBER() OVER ( PARTITION BY ticker, date ORD
