You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Maryann Xue (JIRA)" <ji...@apache.org> on 2014/10/28 22:19:34 UTC

[jira] [Created] (PHOENIX-1392) Support sub-query in the SELECT list

Maryann Xue created PHOENIX-1392:
------------------------------------

             Summary: 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


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)