Search
 
SCRIPT & CODE EXAMPLE
 

SQL

delete recurring email keep smallest id number

DELETE P1
FROM PERSON P1, PERSON P2
WHERE P1.EMAIL=P2.EMAIL AND P1.ID>P2.ID;
Comment

PREVIOUS NEXT
Code Example
Sql :: sqlite explain plan 
Sql :: veri girme SQL 
Sql :: how to run parallel queries in sql server with entity framework 
Sql :: sql select query 
Sql :: SQL Views for Complex Queries 
Sql :: AND Operator (AND) 
Sql :: dependency 
Sql :: Is there a way to use read_sql_query and the query has WHERE column = Variable? 
Sql :: dumping sql table 
Sql :: Stack conditions in CASE statement in PL/SQL 
Sql :: database restoring error 
Sql :: automated psql csv export script on windows 
Sql :: create view in sql server that contain multiple select statements 
Sql :: sütun güncelleme SQL 
Sql :: oracle generate sequence of numbers 
Sql :: sql developer export connections 
Sql :: To revoke create table from users 
Sql :: allow null sql 
Sql :: select from another database 
Sql :: get last 3 years data in mysql 
Sql :: veri seçme SQL 
Sql :: mysql if without else 
Sql :: mysql convert charset 
Sql :: Show mysql account privilleges 
Sql :: redudancy in SQL 
Sql :: mysql maven repo in spring boot 
Sql :: basic sql queries interview questions 
Sql :: pl sql constraint user function 
Sql :: oracle grant create job 
Sql :: ring MySQL enable or disable the auto commit feature 
ADD CONTENT
Topic
Content
Source link
Name
5+3 =