SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Create table t ( id int, val varchar (64) ); insert into t values (1, 'aaaa'), (2, 'bbbb'), (3, 'aaaa'); DELETE from t join t t1 on t.val = t1.val and t.id < t1.id; select * from t;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear