反转行和cols SQLite

Question

我正在开发和iOS游戏，我想交换协议和行

例如，下面是统计数据的表：

StatName (STRING) | StatValue (NUMBER)
--------------------------------------
NbJoker           |      12
--------------------------------------
NbPlayed          |      71
--------------------------------------
NbPause           |      87
--------------------------------------

我需要

NbJoker | NbPlayed | NbPause
----------------------------
12      |     71   | 87

这有可能吗？谢谢!

Answer 1

我不知道SQL Lite。但是如果下面的语法有效的话。

它就像任何SQL中的转置一样。

SELECT SUM(T1) AS NBJOKER, SUM(T2) AS NBPLAYED, SUM(T3) AS NBPAUSE FROM (
SELECT STATVALUE AS T1,O AS T2,0 AS T3 FROM TABLE_X WHERE STATNAME='NBJOKER'
UNION ALL
SELECT 0, STATVALUE, 0 FROM TABLE_X WHERE STATNAME='NBLAYED'
UNION ALL
SELECT 0, 0, STATVALUE FROM TABLE_X WHERE STATNAME='NBPAUSE'
)