Explain the syntax and differences between exists and in in SQL

The difference between exists and in is very small and almost equivalent, but efficiency is often paid attention to in SQL optimization. Today, let’s talk about the difference between exists and in. Exists syntax:Select… From table where existsPut the results of the primary query into the sub query results for verification. If there is data […]