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.
Hello @wang W2,
You can use the same query but instead of saving everything as a double you can save it as a Table and then count the rows in it. Try this:
int TypeNumber = 3;
Table ResultQ = Table.query("SELECT * FROM ItemList1 WHERE Type = $1", TypeNumber);
int Rows = ResultQ.numRows;
You can change the value of TypeNumber to whatever number you want. Depending on the values that you have with the same value the table will increase its size in rows, but you'll obtain the necessary value always.
Hope it works.
Manuel.
You need a WHERE statement, not an if statement:
double result=Table.query("SELECT COUNT(*) FROM ItemList1 WHERE Type = 3")[1][1];
15 People are following this question.
© 1993- FlexSim Software Products, Inc. All Rights Reserved.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
