General information
Category:
Coding, syntax & commands
>I've got a SQL command that looks like it's working, but I noticed all the of "NumRo" values are multiples of 3. I just know this can't be right. What is it actually doing?
>
>SELECT v_tmpart.Insurance,;
> v_tmpart.range,;
> SUM(v_tmpart.subtotal) AS TotalValue,;
> COUNT(v_tmpart.ro) AS NumRo,;
> SUM(v_tmpart.numdays) AS TotalDays,;
> SUM(v_tmpart.numdays) / COUNT(v_tmpart.ro) AS AvgTime;
> FROM v_tmpart;
> WHERE v_tmpart.datein >= ?THIS.dFromDate AND v_tmpart.datein <= ?THIS.dToDate;
> GROUP BY v_tmpart.insurance,v_tmpart.range;
> INTO CURSOR ArtReport
The COUNT(v_tmpart.ro) will not give the expected result if you have null values. Try COUNT(*). Also, you can simplify the AvgTime column to be AVG(v_tmpart.numdays). HTH
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only