here
SELECt * FROM Products
WHERE UnitPrice = (SELECT UnitPrice FROM Products Where UnitPrice >10)
SELECT UnitPrice FROM Products Where UnitPrice >10 if this query return more than one value error will throw. that means you can assign more than one value to Unitprice
.but if you use in operator i it will check the unit price selected and will get appropriate one.
like
SELECt * FROM Products
WHERE UnitPrice IN (10,11,12,13)
// willnot throw error
<pre lang="sql">SELECt * FROM Products
WHERE UnitPrice =(10,11,12,13)</pre>
//throw error