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