Tag：rowid
-
Three methods of deleting duplicate records in Oracle query
For example, there is a personnel table (Table Name: peosons)If you want to record the name, ID number and address of the three fields exactly the same, Copy codeThe code is as follows: select p1.* from persons p1,persons p2 where p1.id<>p2.id and p1.cardid = p2.cardid and p1.pname = p2.pname and p1.address = p2.address The above […]