SQLITE 下面的语句该怎么写在 SQL SERVER 中的语句 是：SELECT(ROW_NUMBER() OVER (ORDER BY Name) - 1) /
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