数据如下
要求提取,非空字段。
表总行数
实现
SELECT MAX(title) title ,MAX(URL) URL,MAX(time) time,MAX(CONTENT ) CONTENT FROM (SELECT NTILE ((SELECT COUNT(*) FROM test )/4) OVER ( ORDER BY id) AS gid,* FROM test ) result GROUP BY gid