SQLITE 下面的语句该怎么写
在 SQL SERVER 中的语句 是：
SELECT
(ROW_NUMBER() OVER (ORDER BY Name) - 1) / 4 + 1 AS TitleRow,
(ROW_NUMBER() OVER (ORDER BY Name) - 1) % 4 + 1 AS TitleColumn,
Name,
Color,
ThumbNailPhoto
FROM Production.MailLabel

在SQLITE 中该怎么写 ？ 谢谢大侠

[解决办法]

SQL code

select ((select count(*) from MailLabel where Name>=a.Name)-1)/4 + 1 as TitleRow,      ((select count(*) from MailLabel where Name>=a.Name)-1) % 4 + 1 as TitleColumn    Name,     Color,     ThumbNailPhotofrom MailLabel a