我如何得到所有月份开始日期表的SQL？ [英] How I get all Month From Date form sql?

问题描述

我有表名工资与下面的数据。

I have table names 'payroll' with following data

month , pay
January , 1200
March , 1500
December , 2000

我要在水晶报表以下结果从存储过程我想，显示这一结果的SQL查询

I want the following result in crystal report from stored procedure i want a SQL query that Display this result

Janury , 1200
February , 000
March , 1500
April , 000
May , 000
June , 000
July , 000
August , 000
September , 000
October , 000
November , 000
December , 2000

请有助于使查询。

在此先感谢

推荐答案

您可以创建与所有其它表12个月的。然后执行一个外部联接与工资表。

You can create another table with all 12 months in it. Then perform a outer join with with payroll table.

这篇关于我如何得到所有月份开始日期表的SQL？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！