SQLITE 下面的语句该如何写

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