Estadisticas de Ventas

[menavas]

Buenos dias amigo, prueba con este query

Código SQL [-]

select * from (SELECT cast (DATEPART("month", Fecha_Venta) as 
CHAR (2)) + '/' + cast ( DATEPART("year", Fecha_Venta) as CHAR (4)) AS FIELD_1, sum(Venta_Efectivo+Venta_Tarjeta+Venta_Credito)  
AS FIELD_2 FROM loans GROUP BY 
cast (DATEPART("month", Fecha_Venta) as CHAR  (2)) + '/' + cast (DATEPART("year", Fecha_Venta) as CHAR (4))) as TEMP 
order by SUBSTRING(field_1, 4, 4),cast (ltrim(rtrim(SUBSTRING(field_1, 1, 2))) as integer)