易截截图软件、单文件、免安装、纯绿色、仅160KB

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的sql语句问题

sqlite不会不支持and 吧?
select * from table where rootid=2 and uid=0 order by orderid asc,id asc
使用上面的语句查询不到数据,可是符合的条件是存在的.我取掉and,就有记录,不知道怎么回事
select * f ......

Sqlite无法更新

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 ......

怎么让sqlite支持中文,谁解决了就给他100分

怎么让sqlite支持中文,谁解决了就给他100分
难道SQLITE不支持中文吗????????

读取出来时乱码

这样试试
C# code:

using System.Data;
using System.Data.SQLite;
//...
using (SQLiteConnec ......

如何将变量中的数据存储到SQLite数据库中

mdb.execDML(L"insert into faultcode values('stu.szNumber', 'stu.szName','stu.szReason', 'stu.szStep')");

我想把结构体变量stu.szNumber中的内容存储到数据 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号