Answers for "avoid duplicate values in sql query"

sql exclude duplicates and find even id

SELECT DISTINCT city FROM tablename WHERE id % 2 = 0

Posted by: Guest on February-26-2021

Query to remove duplicate rows from a table

DELETE FROM Customers WHERE ROWID(SELECT MAX (rowid) FROM Customers C WHERE CustomerNumber = C.CustomerNumber);

Posted by: Guest on November-19-2021

Code answers related to "avoid duplicate values in sql query"