Hello,
Sqlite 3.8.3 implemented recursive CTE.
Sqlite 3.8.4 is shaping to be another great tuning/optimisation release.
Would it be possible to get a small basic subset of the sql windowing
function for Sqlite 3.8.5 ?
If we imagine that the basic windowing is a bit like a CTE 'rewording', it
may be very small in code size, wouldn't it ?
Example :
** a basic SQL window functions usage **
SELECT SalesOrderID, ProductID, OrderQty
,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Total'
,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Avg'
,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Count'
,MIN(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Min'
,MAX(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Max'
FROM SalesOrderDetail
** 'internal' CTE rewording of a basic SQL window functions usage **
With window_this(SalesOrderID, su, av, co, mi, ma) as (
select SalesOrderID,
SUM(OrderQty),AVG(OrderQty),COUNT(OrderQty),MIN(OrderQty),MAX(OrderQty)
FROM SalesOrderDetail )
SELECT SalesOrderID, ProductID, OrderQty
,su AS 'Total'
,av AS 'Avg'
,co AS 'Count'
,mi AS 'Min'
,ma AS 'Max'
FROM SalesOrderDetail inner join
on window_this on SalesOrderDetail.SalesOrderID = window_this.SalesOrderID
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
