sql - 将两个结果合并到一个表中

Question

如果我有

SELECT count(id) FROM students;

count
---------
123

SELECT count(id) FROM staff;

count
---------
456

我希望它像下面这样

nstu  | nsta
--------------
123   | 456

我该怎么做？

Answer 1

只用子查询

SELECT * FROM  
    (SELECT count(id) FROM students) as nstu ,
    (SELECT count(id) FROM staff) nsta;