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不会不支持and 吧?
select * from table where rootid=2 and uid=0 order by orderid asc,id asc
使用上面的语句查询不到数据,可是符合的条件是存在的.我取掉and,就有记录,不知道怎么回事
select * f ......
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存图片路径的代码或例子啊，请帮忙给小弟发一个，tiandaliubin@163.com 真的很急啊。先谢谢了。
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
引用
http://www.sql ......
Java code:
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery("select * from table");//报错的行
rs.last()
用rs.last( ......
visual studio下在wm模拟器里，程序操作sqlite都失败，但在手机上没问题，大家普遍都是这样吗？谁有解决办法？毕竟在模拟器上调试效率比较高。
恩，不会啊，PPC的模拟器是可以的啊..
引用
恩，不会啊，PPC的� ......
