 <p>If you want all results where the Quantity is 20, then all you need to do is specify that in the WHERE clause:</p> <pre><code>SELECT * FROM Product WHERE Quantity = 20; </code></pre> <p>There's no need to include the ORDER BY if you expect the value to be the same throughout. There's also no need to LIMIT unless you want the first number of results where Quantity is 20.</p>