DELETE FROM table_test

WHERE id NOT IN (
SELECT id FROM (SELECT MAX(id) AS id FROM table_test GROUP BY name)  AS t1

);

Categories: 未分类

3 Comments

La Ley De La Atracción · 2019年1月5日 at 上午8:01

Thanks for sharing excellent informations. Your web site is so cool. I’m impressed by the details that you have on this website. It reveals how nicely you perceive this subject. Bookmarked this web page, will come back for more articles. You, my friend, ROCK! I found simply the information I already searched everywhere and simply couldn’t come across. What a perfect website.

google pic · 2018年12月8日 at 下午5:15

Wow. It’s a nice reminder that good people are real in this world.

Dieta Cetogenica Ejemplo · 2018年12月8日 at 上午9:29

There is perceptibly a bundle to know about this. I feel you made some nice points in features also.

发表评论

电子邮件地址不会被公开。