Hi Aneela,
At the moment, Siddhi does not support sub-queries. But, if you just need
to count all the events, you can try Charini's answer. However, if you are
having an event table (i.e. in-memory table) of Employees and you want to
get the count of records in that event table (or get record
Hi Aneela,
If you need to count all the records (without grouping by employee_id) you
will have to do something similar to the following. (This is just one way
of addressing your requirement)
(define an in-memory table to store count)
define table CountTable (count long);
from
Hi,
How can I achieve this sql in siddhi query languge:
select employee_id, (select count(*) from employees)
from employees
I want just a two columns of a stream, one legitimate and other is count of all
records.
Thanks, Regards,Aneela Safdar___
Dev