Shulou(Shulou.com)05/31 Report--

This article mainly shows you "what are the differences between not in and not exists in sql". The content is simple and clear. I hope it can help you solve your doubts. Let me lead you to study and learn "what is the difference between not in and not exists in sql".

Let me first set up two demonstration tables to make it easier to explain:

Create table ljn_test1 (col number)

Create table ljn_test2 (col number)

Then insert some data:

Insert into ljn_test1

Select level from dual connect by level

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.