Sql

DELETE FROM your_table
WHERE rowid not in
(SELECT MIN(rowid)
FROM your_table
GROUP BY column1, column2, column3);

PREVIOUS	NEXT

Code Example
Sql :: What is the compatibility level of a SQL database
Sql :: postgresql transaction discard all
Sql :: oracle apex who is connected
Sql :: date_format for time sql
Sql :: sql get guid
Sql :: mysql show tables in database
Sql :: create database store
Sql :: ALL_TAB_PARTITIONS
Sql :: list columns in table postgres
Sql :: update select
Sql :: oracle add months to sysdate
Sql :: oracle cannot access v$session
Sql :: remove all records from table mysql
Sql :: reset auto increment in mysql
Sql :: sql fill na with 0
Sql :: get first n letter of department name in sql
Sql :: how to get slow query log in mysql
Sql :: alter table
Sql :: Syntax of for-loop in SQL Server
Sql :: oracle grants
Sql :: alter table auto_increment
Sql :: python escape string for sql
Sql :: can you use a where clause for a child query
Sql :: sql like
Sql :: check isolation level in mysql
Sql :: sql create table primary key autoincrement
Sql :: Select last row from SQL Table
Sql :: sql in sublime
Sql :: oracle source code
Sql :: postgres change column type to uuid