Hello,
How can I fix this error ?
Unable to run subquery - cause: FROM in correlated subquery must have USE KEYS clause: FROM product
SELECT
p.name,
p.unitPrice
FROM product p
WHERE price > (
SELECT avg(p.unitPrice) FROM product
)
Hello,
How can I fix this error ?
Unable to run subquery - cause: FROM in correlated subquery must have USE KEYS clause: FROM product
SELECT
p.name,
p.unitPrice
FROM product p
WHERE price > (
SELECT avg(p.unitPrice) FROM product
)
You can’t fix this. This not supported version you using. You must use higher version.
Not sure what is meaning of query. In correlated subquery required secondary index.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.