Hello I have the following query in SQL Server 2008. The database has been moved to a mobile device using SQLite. Can anyone help with a equivalent statement for SQLite?
Select DISTINCT Sites.Customer, Sites.Digit, Count(TblContractTasks.TaskNumber) OVER (PARTITION BY Sites.Digit) As TaskCount FROM TblContractTasks INNER Join (Sites INNER Join TblContractDetails On Sites.Digit = TblContractDetails.SiteDigit) On TblContractTasks.ContractNumber = TblContractDetails.ContractNumber WHERE (Sites.Consultant='xx' ) ORDER BY Sites.Digit -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users