Which product is ordered most frequently?
<pre><code>SELECT ProductID
FROM OrderLine_T
GROUP BY ProductID
ORDER BY COUNT(ProductID) DESC
</code></pre>

<p>I'm ordering the products like this but <code>LIMIT</code> or <code>ROWNUM</code> is not functioning for some reason. I need to have a query with only the single most frequently ordered product. Im Using Teradata and the database name is db_pvfc10_big . Im sorry for the confusing question its my first question and im a beginner in using SQL </p>

<p>Thank you in advance </p>