如何在Ecto中编写相关子查询
例如,什么等同于SQL SELECT查询:
--Heaviest Lemmings per Group
SELECT ld.group_name, ld.id, ld.name, ld.weight
FROM lemming_data ld
WHERE weight = (
SELECT max(weight)
FROM lemming_data
WHERE group = ld.group_name
);在Ecto语法中?我不确定如何引用外部查询的group_name。
发布于 2018-01-15 02:59:31
在Ecto中,如果不使用片段,相关的子查询是不可能的。所以它应该是这样的:
from ld in "lemming_data",
where: ld.weight in fragment("(SELECT max(weight) FROM lemming_data WHERE group = ?)", ld.group_name),
select: ld # or {ld.group_name, ld.id, ld.name, ld.weight}或者:
from ld in "lemming_data",
where: fragment("? = (SELECT max(weight) FROM lemming_data WHERE group = ?)", ld.weight, ld.group_name),
select: ld # or {ld.group_name, ld.id, ld.name, ld.weight}https://stackoverflow.com/questions/48252752
复制相似问题