hello
I want to count The number of rows corresponding to the same type ,like graph below,.Type3 has there rows, how can i count this row num to use sql query code?
like code below:
double result=Table.query("SELECT COUNT(if(type=3,true,null)) FORM ItemList1")[1][1];
but it wont work.
could you enlighten me please?thank you.