[SQL] 纯文本查看 复制代码
SELECT
A, B, C, H1, H2, H3, H4, H5, H6, H7, H8, K1, K2, K3, K4, K5, K6, K7, K8
FROM
(SELECT
A, B, C, H1, H2, H3, H4, H5, H6, H7, H8, K1, K2, K3, K4, K5, K6, K7, K8,
ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS rn
FROM
TableA) AS temp
JOIN TableC ON temp.C = TableC.id
WHERE
temp.rn BETWEEN 2 AND 4
ORDER BY
temp.rn;
[SQL] 纯文本查看 复制代码
SELECT
A, B, C,
CASE
WHEN temp.rn BETWEEN 1 AND 5 THEN H1
ELSE NULL
END AS H1,
CASE
WHEN temp.rn BETWEEN 1 AND 5 THEN H2
ELSE NULL
END AS H2,
CASE
WHEN temp.rn BETWEEN 1 AND 5 THEN H3
ELSE NULL
END AS H3,
CASE
WHEN temp.rn BETWEEN 1 AND 5 THEN H4
ELSE NULL
END AS H4,
CASE
WHEN temp.rn BETWEEN 1 AND 5 THEN H5
ELSE NULL
END AS H5,
CASE
WHEN temp.rn BETWEEN 1 AND 5 THEN K1
ELSE NULL
END AS K1,
CASE
WHEN temp.rn BETWEEN 1 AND 5 THEN K2
ELSE NULL
END AS K2,
CASE
WHEN temp.rn BETWEEN 1 AND 5 THEN K3
ELSE NULL
END AS K3,
CASE
WHEN temp.rn BETWEEN 1 AND 5 THEN K4
ELSE NULL
END AS K4
FROM
(SELECT
A, B, C, H1, H2, H3, H4, H5, K1, K2, K3, K4,
ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS rn
FROM
TableA) AS temp
JOIN TableC ON temp.C = TableC.id
WHERE
temp.rn BETWEEN 1 AND 5
ORDER BY
temp.rn;
