Advertisement
jacknpoe

EstoqueItensDuplicados

Sep 23rd, 2016
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.17 KB | None | 0 0
  1. BEGIN
  2.     SELECT * FROM
  3.         ( SELECT count(*) as quantidade, CD_Estoque, CD_Produto
  4.             FROM EstoqueItem GROUP BY CD_Estoque, CD_Produto ) as SomaItens
  5.         WHERE quantidade > 1;
  6. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement