I have a table with column columna
with data in the same row:
<code>columna
-----------------
a,b,a,b,a,b,a,b
</code>
<code>columna
-----------------
a,b,a,b,a,b,a,b
</code>
columna
-----------------
a,b,a,b,a,b,a,b
I tried this, but it’s not good
<code>duplicated_rows AS
(
SELECT
*,
ROW_NUMBER() OVER (PARTITION BY columna) AS row_num
FROM
tablea
)
SELECT *
FROM duplicated_rows
WHERE row_num > 1;
</code>
<code>duplicated_rows AS
(
SELECT
*,
ROW_NUMBER() OVER (PARTITION BY columna) AS row_num
FROM
tablea
)
SELECT *
FROM duplicated_rows
WHERE row_num > 1;
</code>
duplicated_rows AS
(
SELECT
*,
ROW_NUMBER() OVER (PARTITION BY columna) AS row_num
FROM
tablea
)
SELECT *
FROM duplicated_rows
WHERE row_num > 1;
Not sure how to remove duplicate so I will get result
<code>columna
-------
a,b
</code>
<code>columna
-------
a,b
</code>
columna
-------
a,b
New contributor
mike is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
7