Using SQL, how do I COUNT the number of results from a query?
<p>I'm quite new to SQL and coding generally. </p>

<p>I have a SQL query that works fine. All I want to do now is return the number of rows from that query result. </p>

<p>The current SQL query is:</p>

<pre class="lang-sql prettyprint-override"><code>SELECT 
    Progress.UserID, Questions.[Question Location],
    Questions.[Correct Answer], Questions.[False Answer 1],
    Questions.[False Answer 2], Questions.[False Answer 3]
FROM
    Questions 
INNER JOIN
    Progress ON Questions.[QuestionID] = Progress.[QuestionID]
 WHERE 
    (((Progress.UserID) = 1) AND 
     ((Progress.Status) &lt;&gt; "Correct")
    );
</code></pre>

<p>I know I need to use </p>

<pre><code>SELECT COUNT(*)
</code></pre>

<p>...though not quite sure how I integrate it into the query. </p>

<p>I then intend to use OLEDB to return the result to a VB Windows Form App. </p>

<p>All help is much appreciated.</p>

<p>Thanks! Joe</p>