Advertisement
econz

Firebird - Contar pedidos listando os itens

Apr 8th, 2019
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.33 KB | None | 0 0
  1. SELECT
  2.    FIRST 100
  3.    I.ID,
  4.    I.ID_PEDIDO,
  5.    P.DATA,
  6.    iif(( lag(I.ID_PEDIDO) OVER ()) = I.ID_PEDIDO , 0, 1)  AS C_CONT_PED
  7. FROM PEDIDO P
  8. INNER JOIN ITENSPEDIDO I ON I.ID_PEDIDO = P.ID
  9. WHERE
  10.    P.DATA >= '03/01/2019'
  11. ORDER BY
  12.    P.DATA, P.ID
  13.  
  14.  
  15. -- Para contar a quantidade de pedidos, basta dar um sum na coluna C_CONT_PED
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement