[sqlite] Is this rewrite of a query OK

[Cecil Westerhof]

I had the following query:
SELECT MIN(totalUsed)                  AS minimum
,      MAX(totalUsed)                  AS maximum
,      MAX(totalUsed) - MIN(totalUsed) AS range
FROM   quotes

But I did not like it because I repeated the MIN and MAX. So I rewrote it
to the following:
SELECT Minimum
,      Maximum
,      Maximum - Minimum AS Range
FROM   (
    SELECT MIN(totalUsed) AS Minimum
    ,      MAX(totalUsed) AS Maximum
    FROM   quotes
)

Is this acceptable, or could there be unintended consequences? Is there a
better way to do it?

-- 
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users