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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users