Microsoft KB Archive/70824: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q70824 to Microsoft KB Archive/70824 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
(No difference)
|
Latest revision as of 19:29, 12 August 2020
PRSQL9103004: Results Incorrect with GROUP BY and Sum in Views ID Number: Q70824
1.10 OS/2 buglist1.10
Summary:
PROBLEM ID: PRSQL9103004
SYMPTOMS A view created with a GROUP BY clause and an aggregate expression produces incorrect cardinality in the result set.
RESOLUTION Instead of creating a view, use a temporary table or the original table.