select distinct datepart(yy,datedb) as vYear,datepart(mm,datedb) as vMonth ,'0' as isIn
from voucher
order by vYear,vMonth你那个也可以的.什么问题?
请给出表结构,测试数据,相关算法和需要的结果.谢谢!
from voucher
order by vYear,vMonth你那个也可以的.什么问题?
请给出表结构,测试数据,相关算法和需要的结果.谢谢!
select distinct datepart(yy,datedb) as vYear,datepart(mm,datedb) as vMonth ,'0' as isIn
from voucher
order by vYear,vMonth试试