计算每年收入至今年包括今年的累加结果:
id year money
------ ------ --------
1 2011 100
2 2012 200
3 2013 300
要求的output:
year moneys
------ --------
2011 100
2012 300
2013 600
SELECT
a.`year`,
(SELECT
SUM(money)
FROM
coupon_a
WHERE id <= a.id) AS moneys
FROM
coupon_a a ;
查询每分类前三个产品,不考虑排序方式等,,
SELECT
main.*,
t.name
FROM
product main,
category t
WHERE
(SELECT
COUNT(1)
FROM
product sub
WHERE main.cat_id = sub.cat_id
AND main.id > sub.id) < 3
AND main.cat_id = t.id;
SELECT
COUNT(1)
FROM
product sub
WHERE main.cat_id = sub.cat_id
AND main.id > sub.id
这个不具有实用性,但是是了解关联子查询的一个很好的例子