SQLQuery incorrect output
hi,
I ran the sql query below on zoho analytics and the result differs from what I got when i ran the same query on MSSQL Management studio.
SELECT
e.ClaimId,
d.Diagnosis,
SUM(e.InitialAmount) total_salary
FROM
ClaimDrug e
INNER JOIN
Claim d ON d.Id = e.ClaimId
GROUP BY e.ClaimId, d.Diagnosis
(A)Result when query is run on zoho analytics:
(B) Result when query is ran on MSSQL Management Studio:
| ClaimId | Diagnosis | total_salary |
| 34 | ACUTE EXACERBATION OF PUD DUE TO NSAID,CAR OCCUPANT INJURED IN COLLISION WITH PEDAL CYCLE, UNSPECIFIED CAR OCCUPANT INJURED IN TRAFFIC ACCIDENT | 5670 |
| 35 | PRESBYOPIA | 32000 |
| 36 | URTI R/O SINUSITIS,CAR OCCUPANT INJURED IN COLLISION WITH PEDAL CYCLE, UNSPECIFIED CAR OCCUPANT INJURED IN TRAFFIC ACCIDENT | 5575 |
| 37 | HYPERTENSION, ACUTE EXECERBATION OF PUD,CAR OCCUPANT INJURED IN COLLISION WITH PEDAL CYCLE, UNSPECIFIED CAR OCCUPANT INJURED IN TRAFFIC ACCIDENT | 5450 |
| 38 | ,CAR OCCUPANT INJURED IN COLLISION WITH PEDAL CYCLE, UNSPECIFIED CAR OCCUPANT INJURED IN TRAFFIC ACCIDENT | 11340 |
| 39 | HTN,CAR OCCUPANT INJURED IN COLLISION WITH PEDAL CYCLE, UNSPECIFIED CAR OCCUPANT INJURED IN TRAFFIC ACCIDENT | 5150 |
| 40 | PRESBYOBIA | 36000 |
| 41 | MYOPIC PRESBYOPIA,CAR OCCUPANT INJURED IN COLLISION WITH PEDAL CYCLE, UNSPECIFIED CAR OCCUPANT INJURED IN TRAFFIC ACCIDENT | 16000 |
| 42 | ENTERIC FEVER,CAR OCCUPANT INJURED IN COLLISION WITH PEDAL CYCLE, UNSPECIFIED CAR OCCUPANT INJURED IN TRAFFIC ACCIDENT | 6354 |