display empty row
<pre><code>SELECT 
    workdate, 
    SUM(Sam) ttlsam 
FROM 
    Sah 
WHERE 
    workdate BETWEEN '01 May 2016' AND ' 05 May 2016' 
GROUP BY 
    workdate
</code></pre>

<p>I have execute the above command and result is </p>

<pre><code>Workdate ttlsam
02 may   10
03 may   20
04 may   40
</code></pre>

<p>Here 01 and 05 May are not showing because those two date has no data. But I want like this. I mean although 01 and 05 may don't have data they needs to display 0 or null value in ttlsam field</p>

<pre><code>01 may   0
02 may   10
03 may   20
04 may   40
05 may   0
</code></pre>