Validate my Sqlite Query? -


I have a table in the slit with these fields: - number, value pressed, time, date, month, year < / P>

The output should be date, yes, no and mood. My query gives nearly the appropriate results, but the problem is how the total value can be pressed on a specific date. Here the query is using m: "date, year, month, calculation (*) yes from value_table where between date 25 and 30 and value_pressed = 'yes' from the date of the group".

is the date 25 and 30 which is in NSstring.

The output of this query is: Enter image details here

I have already used the Sangh. But it is not returning the desired output. Please help me

Please help me ... I really thank you for this ..

I'm not sure what you are asking, but if you want total value, then you should use the SUM function instead of the COUNT function: 

  SELECT date, year , Month, SUM (Value_Pressed) AS Yes Value_table Date between 25 and 30 Value_pressed = 'Yes' Group Date

Comments

Post a Comment