Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1392

Support sub-query in the SELECT list

        Details

        • Type: Task
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Affects Version/s: 3.0.0, 4.0.0
        • Fix Version/s: None
        • Labels:
          None

          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;

            Activity

            Hide
            Permalink
            jamestaylor James Taylor added a comment -

            Maryann Xue - would you mind collecting these JIRAs under a single top level one so we can point users to gaps in our SQL support?

            Show
            jamestaylor James Taylor added a comment - Maryann Xue - would you mind collecting these JIRAs under a single top level one so we can point users to gaps in our SQL support?

              People

              • Assignee:
                maryannxue Maryann Xue
                Reporter:
                maryannxue Maryann Xue
              • Votes:
                3 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - 120h
                  120h
                  Remaining:
                  Remaining Estimate - 120h
                  120h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                    Development