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,
ThumbNailPhoto
from MailLabel a
SQL code:
sqlite> select * from MailLabel;
name|color|ThumbNailPhoto
1|1|1
2|2|2
3|3|3
4|4|4
5|5|5
6|6|6
7|7|7
sqlite> 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,
...> ThumbNailPhoto
...> from MailLabel a;
TitleRow|TitleColumn|name|color|ThumbNailPhoto
1 | 1 | 1 | 1 | 1
1 | 2 | 2 | 2 | 2
相关问答:
Sqlite返回多个查询结果集的时候,有什么办法能移动到下一个结果集上去
比如
有语句
select * from sqlite_master where type='table';select * from sqlite_master where type='index';
......
没有主键,我只要删除前N条记录。n数值大概在千万级别的。
用set rowcount n
引用
用set rowcount n
支持
SELECT IDD=IDENTITY(INT,1,1),* INTO #T from TB
DELETE #T WHERE IDD NOT I ......
SELECT qsmallClass.Sname, qproducts.pmodel, qproducts.punit, qmaintain.mcount from qsmallClass INNER JOIN (qproducts INNER JOIN qmaintain ON qproducts.pid = qmaintain.pid) ON qsmallClass.Sid = qproduc ......
C# code:
public static bool UpdateFriendUrl(int id, string cnName, string jpName, string logoUrl, string site, int order)
{
string sql = "update FriendUrl set SiteNameCN=@SiteNameC ......