HOW TO REMOVE REPEATED ROWS IN MYSQL

Question

HOW TO REMOVE REPEATED ROWS IN MYSQL

Navigation

#1 by (0 votes)

2

Friends, good evening, I hope and you can help me ...

I have the following inconvenience or good is not an inconvenience is rather ignorance ...

I have this table in Mysql

and I need to make a selection to the database and can show me the existence to date and I am doing it this way.

As you can see in the first image in the inventory movements, I select the balance + the entry - the exit to obtain the total, why do I put it in the where < = 'Date'? because if in the software I make a query on day 18 for example the query can not return null since the previous day there are stocks in the warehouse, now the error lies and if they are set is in the article repeated in the warehouse repeated, I explain. the amount 8 is from a movement in a past day but the net amount to date is 1.

THE MAIN QUESTION TAKING INTO ACCOUNT THE ABOVE IS HOW CAN I RECOVER THE FIRST RECORD OF THE DUPLICATE ARTICLE IN THE DUPLICATE WAREHOUSE, SINCE I AM HAVING AN ERRONEOUS INFORMATION?

I would really appreciate the soul of the person who wants to help me with this topic because I know it's simple but I do not know their solution.

Thank you very much.

mysql

asked by Daniel Giraldo 18.06.2018 в 05:10

source

1 answer

React Native [Error: Camera is not running] Is there a way to reboot the camera within a specific view? Error match is not defined no-undef in react.js

score 0 · Answer 1

I think you could try this, I hope it works for you.

SELECT E.ART_CODIGO, E.BOD_CODIGO, (E.EXIS_SALDO + E.EXIS_ENTRADA - E.EXIS_SALIDA) AS CANTIDAD, E.EXIS_FECHA FROM EXISTENCIA E
INNER JOIN ARTICULO A ON A.ART_CODIGO = E.ART_CODIGO
INNER JOIN BODEGA B ON B.BOD_CODIGO = E.BOD_CODIGO 
WHERE E.EXIS_FECHA <= "2018-06-17"
GROUP BY E.ART_CODIGO, E.BOD_CODIGO
ORDER BY 1 DESC,2 DESC, 4 DESC;