Advertisement
xickoh

query funcionario decrescente valor vendas

Jun 17th, 2018
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. select Fu.idFuncionario, Fu.nome sum(A.preco * V.quantidade) as valor_vendas
  2. from VendasArtigos V join
  3. Artigo A
  4. on V.idArtigo = A.idArtigo
  5. join Fatura F
  6. on F.idFatura = V.idFatura
  7. join Funcionario Fu
  8. on fu.idFuncionario = f.idFuncionario
  9. where F.dataHora <= getdate() and F.dataHora > dateAdd("m", -1, getdate())
  10. group by Fu.idFuncionario
  11. order by valor_vendas DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement