SQL Query to compare column values?

[rajankur6494]

[ FlexSim 21.0.10 ]

Hi Team,

I have global table data as given below:

RoomName AllocatedRoom

ABC DEF

ABC ABC

DEF DEF

DEF ABC

ABC ABC

DEF DEF

How can I count values using SQL query where RoomName==AllocatedRoom?

Thank you!

[joerg_vogel_HsH · Accepted solution]

count_query.fsm

Table mytable = Table.query("SELECT COUNT([Col 1]) FROM GlobalTable1 WHERE [Col 1] = [Col 2]");
mytable.cloneTo(Table("dump"));

[jason_lightfootVL7B4]

Or

SELECT SUM([RoomName]=[AllocatedRoom]) FROM GlobalTable1

[kavika_faleumu]

Hi @Ankur A3, was Joerg Vogel's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.