What is the difference between IN and an equals sign?

Question

SQL

Actually, the same question, gentlemen.

Answer 1

= is used for direct comparison with a single value,
works well with nested queries with an aggregate function, or an exact character-by-character value
IN is used if there are several comparison options, and any of the above is suitable, for example,
I need to select a sweater, where the color is IN ('blue', 'brown', 'green')
would be faster than writing
WHERE color = 'blue' OR color = 'brown' OR color = 'green'

Answer 2

x = a
или
x IN [a, b, c]

In my opinion the difference is obvious.

Answer 3

equality with one of the values ​​vs. equality with one value

Answer 4

https://www.w3schools.com/sql/sql_in.asp