mysql - 结合具有限制的多个 SQL 查询

Question

这是我的 table

DB -Fiddle Link还有一个 SQL FIDDLE 链接

`id`, `pname`, `comapny_id`, `premium`
(1, 'aaaa', 1, '1'),
(2, 'bbbb', 1, '2'),
(3, 'cccc', 1, '3'),
(4, 'dddd', 1, '2'),
(5, 'eeee', 1, '1'),
(6, 'ffff', 1, '3'),
(7, 'gggg', 1, '3'),
(8, 'hhhh', 1, '2'),
(9, 'iiii', 1, '1'),
(10, 'jjjj', 1, '2');

我想合并 3 个查询。

我试过了

SELECT *
FROM query_test 
WHERE company_id = 1 AND premium = 1 
LIMIT 3 
INNER JOIN query_test ON SELECT * FROM query_test WHERE company_id = 1 AND premium = 2 LIMIT 4;

但这对我不起作用。如何使用 SQL join 加入以下三个查询？我正在从 W3Schools 学习 SQL 连接。

查询#1:

SELECT * 
FROM query_test 
WHERE company_id = 1 AND premium = 1 
LIMIT 3

查询#2:

SELECT * 
FROM query_test 
WHERE company_id = 1 AND premium = 2 
LIMIT 4

查询#3:

SELECT * 
FROM query_test 
WHERE company_id = 1 AND premium = 3 
LIMIT 3

我怎样才能用最少的时间实现这一点？

帮助应该受到赞赏。

谢谢你。

Answer 1

尝试使用 LIMIT 和 UNION，语法正确:

(SELECT * FROM query_test WHERE comapny_id = 1 AND premium = 1 LIMIT 3)
UNION ALL
(SELECT * FROM query_test WHERE comapny_id = 1 AND premium = 2 LIMIT 4)
UNION ALL
(SELECT * FROM query_test WHERE comapny_id = 1 AND premium = 3 LIMIT 3);