I have a table which contains the following columns:

```
ProductName copmanyname arianame    bno     mrp  exp_date   Date        qty 
DANZEN DS   HELIX PHARMA    CITY 1  J026    215 01-Feb-16   30-Oct-19   41  
DANZEN DS   HELIX PHARMA    CITY 2  J026    215 01-Feb-16   30-Aug-19   2   
HIPRO       HELIX PHARMA    CITY 1  J035    225 01-Feb-16   30-Nov-18   20  
NOGARD      HELIX PHARMA    CITY 1  J010    135 01-Feb-16   30-Nov-20   2   
NOGARD      HELIX PHARMA    CITY 2  J010    135 01-Feb-16   30-Nov-20   8   
NOGARD      HELIX PHARMA    TANK    J004    135 01-Feb-16   30-May-20   1   
ALINAMIN F  HELIX PHARMA    CITY 1  I002    195 02-Feb-16   30-Sep-19   2   
ALINAMIN F  HELIX PHARMA    CITY 2  H003    195 02-Feb-16   30-Nov-18   1   

```

I want to display the record on specific date, and which Record have same Product and company and bno and mrp then the qty of the these record wil sum. for example in above table :

```
ProductName copmanyname arianame    bno     mrp  exp_date   Date        qty
NOGARD      HELIX PHARMA    CITY 1  J010    135 01-Feb-16   30-Nov-20   30  

```

I tried with the following statement but it not sum up the qty, display all record.

```
SELECT  
    ProductName, CopmanyName, AriaName, bno, mrp, exp_date, 
    Sum(quantity) AS qty 
FROM
    q_saledetail
GROUP BY 
    ProductName, CopmanyName, AriaName, bno, mrp, exp_date,date 
WHERE
    date = any date

```