/MySQL相邻去重*/

MySQL相邻去重

SELECT room
FROM bracelet_info AS table1
WHERE table1.room != 
(
  SELECT table2.room
  FROM bracelet_info AS table2
  WHERE table1.uid < table2.uid
  ORDER BY table2.uid
  LIMIT 1
)
OR NOT EXISTS 
(
  SELECT *
  FROM bracelet_info AS table3
  WHERE table1.uid < table3.uid
)

记录一下，出处找不到了

此为博主副博客，留言请去主博客，转载请注明出处：https://www.baby7blog.com/myBlog/31.html