[code=SQ]Lselect substring(convert(varchar(10),date,120),1,7),sum(amount) from tb group by select substring(convert(varchar(10),date,120),1,7) order by 1[/code]
[code=SQ]Lselect convert(varchar(7),date,120),sum(amount) from tb group by convert(varchar(7),date,120)[/code]
[code=SQ]L select convert(varchar(7),date,120) as date,sum(amount) as total from tb group by convert(varchar(7),date,120) [/code]
--L select convert(varchar(7),date,120) as date,sum(amount) as total from tb group by convert(varchar(7),date,120)
group by select substring(convert(varchar(10),date,120),1,7)
order by 1[/code]
from tb
group by convert(varchar(7),date,120)[/code]
select convert(varchar(7),date,120) as date,sum(amount) as total
from tb
group by convert(varchar(7),date,120)
[/code]
select convert(varchar(7),date,120) as date,sum(amount) as total
from tb
group by convert(varchar(7),date,120)