[
https://issues.apache.org/jira/browse/PHOENIX-1392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14314736#comment-14314736
]
James Taylor commented on PHOENIX-1392:
---------------------------------------
[~maryannxue] - would you mind collecting these JIRAs under a single top level
one so we can point users to gaps in our SQL support?
> Support sub-query in the SELECT list
> ------------------------------------
>
> Key: PHOENIX-1392
> URL: https://issues.apache.org/jira/browse/PHOENIX-1392
> Project: Phoenix
> Issue Type: Task
> Affects Versions: 3.0.0, 4.0.0, 5.0.0
> Reporter: Maryann Xue
> Assignee: Maryann Xue
> Original Estimate: 120h
> Remaining Estimate: 120h
>
> Example:
> SELECT Name, ListPrice,
> (SELECT AVG(ListPrice) FROM Production.Product) AS Average,
> ListPrice - (SELECT AVG(ListPrice) FROM Production.Product)
> AS Difference
> FROM Production.Product
> WHERE ProductSubcategoryID = 1;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
