Skip to content

Instantly share code, notes, and snippets.

@laolai
Created September 18, 2021 06:54
Show Gist options
  • Save laolai/62f4bdde238e2e59b02875197e1cea67 to your computer and use it in GitHub Desktop.
Save laolai/62f4bdde238e2e59b02875197e1cea67 to your computer and use it in GitHub Desktop.
商品
select distinct(商品) from 商品表 where 商品 not in(select 商品 from 商品表 where 类型=1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment