Guys I have a table in database like this. open to see

I need to fetch data such that i have only variety and number of grafts each date summed up without repetition.

I get this instead: result

CodePudding user response：

I think, this is the query you are looking for

select sum(variety), sum(number_grafts), date 
from <table_name> 
group by date