Help adding the following query (ORACLE)

Question

Help adding the following query (ORACLE)

Navigation

#1 by (0 votes)

0

I have the following selection which I need to add the amount when the same item is repeated in the same container and lot.

SELECT 
LOTE,FECHA_CADUCIDAD,CANTIDAD,CODIGO_CONTENEDOR,ARTICULO,NUMERO_PEDIDO
FROM XXOSI.XXOSI_OMBULLN_SIS_IN_T 
WHERE NUMERO_PEDIDO = 'I-142585778531' 
AND ARTICULO = '43758' 
AND CODIGO_CONTENEDOR = '4'
ORDER BY FECHA_CADUCIDAD;

If I run this query it brings me the following information:

As you can see I have the same number of articulo . the same lote the same contenedor the same numero de pedido

What I need is to be able to add the amount and show a single item record with the summed amounts, besides that if the Lot is different the query is opened and the amount is not added, but it shows all the article records in the same container for an order number but with a different batch.

Any help is appreciated.

oracle-11g

asked by Ikabod 23.02.2018 в 21:09

source

1 answer

Which .ini file uses php (-develoment or -production)? Simple threads in Java with files

score 0 · Answer 1

You can try a subquery inside your SELECT like this:

SELECT a*
(select 
   sum(CANTIDAD) 
     from XXOSI.XXOSI_OMBULLN_SIS_IN_T 
       where LOTE = a.LOTE 
       and ARTICULO = a.ARTICULO 
       and CODIGO_CONTENEDOR = a.CODIGO_CONTENEDOR) as CANT_TOTAL

   FROM XXOSI.XXOSI_OMBULLN_SIS_IN_T a
        WHERE a.NUMERO_PEDIDO = 'I-142585778531' 
           AND a.ARTICULO = '43758' 
           AND a.CODIGO_CONTENEDOR = '4'
             ORDER BY a.FECHA_CADUCIDAD;

I hope it serves you.