Uid is thr column which you should delete one of

Question

Uid is thr column which you should delete one of

uids? What if there are 3 equal uids?
Still i need to know if there is a column which uniquely identies the rows such as a date column which shows the inserted date

#english #programming #sql

0

21.01.2024

2 ответов

31 просмотр

.

.
DELETE FROM azolar WHERE (uid) NOT IN ( SELECT...

this is not working

0

11 месяцев назад

. · Accepted Answer

.

DELETE FROM azolar WHERE (uid) NOT IN ( SELECT t.uid FROM ( SELECT MAX(uid) as uid FROM azolar GROUP BY uid HAVING COUNT(*) > 1 ) t );

0

11 месяцев назад

169 похожих чатов

Uid is thr column which you should delete one of

2 ответов

Похожие вопросы