在sql中的前两行之后添加所有行

Question

轿车sum_of_solds秩

本田150000 2

马自达120000 3

特斯拉180000 1

丰田60000 4

我想在前两行之后添加所有行。所以在上面的例子中，我想要这样的东西：

轿车sum_of_solds秩

特斯拉150000 1

本田120000 2

其他180000人

Answer 1

您可以使用联合查询：

SELECT car, sum_of_solds, "rank"
FROM
(
    SELECT car, sum_of_solds, CAST("rank" AS varchar(10)) AS "rank", "rank" AS pos
    FROM yourTable
    WHERE "rank" <= 2
    UNION ALL
    SELECT 'others', SUM(sum_of_solds), 'others', 3
    FROM yourTable
    WHERE "rank" > 2
) t
ORDER BY pos;