In SQL this command work ok:
SELECT TOP 20 * FROM (SELECT ROW_NUMBER() OVER (ORDER BY t0.ProductId) AS [ROW_NUMBER], * FROM Product AS [t0]) AS [t1] WHERE [t1].[ROW_NUMBER] > 0 * 20;
Now I try same with SQlite. I know that I must replace TOP with LIMIT but dont know where to put. Always get something like "SQLite error near "(": syntax error" or "SQLite error near "*": syntax error"
etc... And I not sure that command [ROW_NUMBER] or ROW_NUMBER() work in SQlite... Help any suggestion?
Aucun commentaire:
Enregistrer un commentaire