SELECT 1/2,total,sb_ondate,likes FROM ( SELECT sb_ondate,COUNT(*) AS total,STrftIME("%w",sb_ondate) AS weekDay,COUNT(CASE WHEN sb_reaction = 'like' THEN sb_ID END) AS likes FROM dIEt GROUP BY weekDay) AS f;
谢谢.
将两个除数中的一个作为一个实数:SELECT 1 / CAST(2 AS REAL),...
示例交互式Python会话:
>>> import sqlite3>>> c = sqlite3.connect(':memory:')>>> c.execute("create table t (a int,b int);")<sqlite3.Cursor object at 0x7f9b0e9539d0>>>> c.execute("insert into t values (1,2)")<sqlite3.Cursor object at 0x7f9b0e953ad8>>>> conn.execute("select a / cast(b as real) from t").fetchone()(0.5,)总结
以上是内存溢出为你收集整理的sqlite – 类型转换问题全部内容,希望文章能够帮你解决sqlite – 类型转换问题所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)