[PHOENIX-1392] Support sub-query in the SELECT list

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0, 4.0.0
• Assignee: Maryann Xue
• Reporter: Maryann Xue
• Due: 31/Dec/14
• Created: 28/Oct/14 21:19
• Updated: 05/Aug/15 17:27

Description

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;