javascript对象上的复杂SQL查询

Alasql Javascript SQL库是专门为此类任务设计的：

<script src="alasql.min.js"></script><script>    var groups = [{id:4, name:"abcd", id_group:"1"},          {id:5, name:"efgh", id_group:"1"},          {id:6, name:"ijkl", id_group:"1"},          {id:4, name:"abcd", id_group:"2"},          {id:7, name:"mnop", id_group:"2"}];    var res = alasql('select id_group, count(id) as cnt from ?         where id in (4,7) group by id_group having cnt = 2',[groups]); </script>

您可以在jsFiddle中尝试此示例。

我修改了一个SQL表达式，因为Alasql在HAVINg子句中不支持聚合函数（例如COUNT，SUM，MAX，MIN）。