Fórum Pegando ROW sem ID #28853

SELECT ps.´Description´ AS ´Estado´, pp.´Description´ AS ´Modo de Pagamento´, CASE WHEN p.´Paid´ = 1 THEN ´Pago´ ELSE ´Devendo´ END AS ´Pagamento´ FROM ´Payment´ p INNER JOIN ´PaymentType´ pp ON p.´PaymentTypeID´ = pp.´PaymentTypeID´ INNER JOIN ´PaymentStatus´ ps ON p.´PaymentStatusID´ = ps.´PaymentStatusID´ GROUP BY p.´PaymentTypeID´, p.´PaymentStatusID´,pp.´Description´,ps.´Description´, p.´Paid´ ORDER BY p.´Paid´ DESC

SELECT ps.´Description´ AS ´Estado´, pp.´Description´ AS ´Modo de Pagamento´, CASE WHEN p.´Paid´ = 1 THEN ´Pago´ ELSE ´Devendo´ END AS ´Pagamento´, COUNT(*) AS ´Registros´, Sum(p.´Amount´) AS ´Fatura´, AVG(p.´Amount´) AS ´Média´, Max(p.´Amount´) AS ´Maior Fatura´, Max(p.´Amount´)*COUNT(*) AS ´Máxima Estimativa´, Min(p.´Amount´) AS ´Menor Fatura´, Min(p.´Amount´)*COUNT(*) AS ´Minima Estimativa´ FROM ´Payment´ p INNER JOIN ´PaymentType´ pp ON p.´PaymentTypeID´ = pp.´PaymentTypeID´ INNER JOIN ´PaymentStatus´ ps ON p.´PaymentStatusID´ = ps.´PaymentStatusID´ GROUP BY p.´PaymentTypeID´, p.´PaymentStatusID´,pp.´Description´,ps.´Description´, p.´Paid´ ORDER BY p.´Paid´ DESC