sqlite(4或3)没有任何内置的功能,但可以手动执行：

SELECT x
FROM MyTable
ORDER BY x
LIMIT 1
OFFSET (SELECT COUNT(*)
        FROM MyTable) / 2

当有数量的记录时,通常将中位数定义为两个中间记录的平均值.
在这种情况下,平均值可以这样计算：

SELECT AVG(x)
FROM (SELECT x
      FROM MyTable
      ORDER BY x
      LIMIT 2
      OFFSET (SELECT (COUNT(*) - 1) / 2
              FROM MyTable))

结合奇数和偶数情况,结果如下：

SELECT AVG(x)
FROM (SELECT x
      FROM MyTable
      ORDER BY x
      LIMIT 2 - (SELECT COUNT(*) FROM MyTable) % 2    -- odd 1,even 2
      OFFSET (SELECT (COUNT(*) - 1) / 2
              FROM MyTable))