title: How to select five selling product in Oracle SQL?
body: <p>EX: 5.  Write a SELECT statement that uses the view that you created in exercise 4 to get total sales for the five best selling products.</p>
  <pre><code>SELECT TOP 5 Product_Name, Order_Total
  FROM Product_Summary 
  ORDER BY Order_Total DESC
  </code></pre>
  <p>I am getting this error :</p>
  <blockquote>
  <p>Error at Command Line : 2 Column : 12<br />
  Error report -<br />
  SQL Error: ORA-00923: FROM keyword not found where expected<br />
  00923. 00000 -  &quot;FROM keyword not found where expected&quot;<br />
  *Cause:<br />
  *Action:</p>
  </blockquote>
  <p>Please I been trying to solve this but I don't how to fix it.</p>