mysql - 我的目标是合并这两个查询。我在以单独的方式执行时存在差异

Question

Image1 Image帮我合并这两个给定的查询

SELECT DISTINCT vehicle_no FROM petty_cash;

SELECT COUNT(variation) as bal FROM petty_cash WHERE variation<0;

提前致谢。

标签： mysql

Answer 1

I'm not sure about your output but i can combine those 2 queries as below.

SELECT DISTINCT vehicle_no, COUNT(variation) as bal FROM petty_cash WHERE variation < 0;