Posts by João Pedro Dutra • 11 points

• 0

  votes

  1

  answer

  512

  views

  A: Sub-Select with MAX / SUM / INNER JOIN?

  Thanks, Motta! I got it using the tools you gave me. It looks like this: 'SELECT Descricao, MAX(Faturamento) Faturamento FROM (SELECT SUM(P.preco * I.qtde) Faturamento, P.descricao FROM produto P…

  mysql sql select-sql

  answered 7 years, 6 months ago João Pedro Dutra 11

• 1

  votes

  1

  answer

  512

  views

  Q: Sub-Select with MAX / SUM / INNER JOIN?

  I need to make a SUM within a MAX to return higher product billing within a summary. I got by doing this: SELECT MAX(Faturamento) MAX_Faturamento FROM (SELECT SUM(P.preco * I.qtde) Faturamento FROM…

  mysql sql select-sql

  asked 7 years, 6 months ago João Pedro Dutra 11