Advertisement
martinsluis

QTD DE VENDA E SOMA NO ANO

Sep 20th, 2019
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.20 KB | None | 0 0
  1. SELECT
  2.     COUNT(V.ECF_NUMERO),
  3.     SUM(V.ECF_TOTAL)
  4.  
  5. FROM
  6. VENDAS V
  7.  
  8. INNER JOIN CLIENTES C ON (V.CLI_CODIGO = C.CLI_CODIGO)
  9.  
  10. WHERE
  11. V.CLI_CODIGO = '11522'
  12. AND EXTRACT(YEAR FROM V.ECF_DATA) = 2019
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement