I’ve got a list of requests that I place into a table.
There is only one unique column in the table. rownumber.
There will be no NULLs in any rows.
However after the table has been populated I want to remove duplicate rows. (where every column in two or more rows are the same except for the row number.\
(psuedo code!)
Select distinct * from Table; was what first came to mind but then the row number is always different,
So how can i, without having to type every column name except the row number, write that in SQL?
Select distinct (* except rownumber) from Table;
Any other thought on duplicate record removal?
I would think this isn’t an uncommon thing for DB managers to face.
I’ve found a few SQL statements on giggle but i think being able to express a list of all but one column in the database may be what I’m looking for.
(Assuming also that the statement i’ve expressed actually do what i think they should, but I haven’t tested them yet,)