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,
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

Reply via email to