var alasql = require("alasql");
alasql("CREATE TABLE tbleName (a INT, b INT,c INT)");
var data = [{
a: 1,
b: 1,
c: 1
}, {
a: 1,
b: 2,
c: 1
}, {
a: 1,
b: 3,
c: 1
}, {
a: 2,
b: 1,
c: 1
}];
var insertedCount = alasql('INSERT INTO tbleName SELECT * FROM ? WHERE a IN(SELECT a FROM tbleName GROUP BY a) GROUP BY a', [data]);
the above would get an error: