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 mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev