[Solved] return all rows of a table including duplicate rows

by


to get all rows, just use

select * from tableName

If you want to filter the duplicates out just add

select distinct * from tableName

if you want to group by, you can do:

select column1, column2 
sum(column1, column2) as sumCol
from table    
group by column1,column2

or using a window function

select *
sum(column1, column2) over (partition by column5) as sum
from table

1

solved return all rows of a table including duplicate rows