Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- id || data || column
- 1 || 10 || x
- 1 || 20 || y
- 1 || 30 || y
- 1 || 15 || z
- var queryPartOne = await db.table.findOne({
- attributes: [
- [db.Sequelize.fn("sum", db.Sequelize.col("data")), "datas"]
- ]
- )}
- var queryPartTwo = await db.table.findOne({
- where: {
- column: z
- },
- attributes: [
- [db.Sequelize.fn("sum", db.Sequelize.col("data")), "datas"]
- ]
- )}
- var net = queryPartOne.datas- queryPartTwo.datas * 1,25;
Add Comment
Please, Sign In to add comment