MySQL Forums
Forum List  »  Spanish

mostrar valores duplicados
Posted by: diego scocco
Date: March 05, 2012 06:45AM

Tengo un array que contiene los codigo de la clave primaria 1000,2000,2001,1000.

Select * from stock where codigo IN ('1000','2000','2001','1000')

Lo que necesito es que me muestre 2 veces el valor 1000, me muestra solamente los valores no repetidos.
Me da como resultado 3 registros y no 4.

Saludos.

Options: ReplyQuote


Subject
Views
Written By
Posted
mostrar valores duplicados
3078
March 05, 2012 06:45AM
1105
March 05, 2012 12:59PM
945
March 05, 2012 03:15PM
724
March 05, 2012 07:28PM
625
March 06, 2012 09:21AM
1100
March 06, 2012 11:25AM
918
March 06, 2012 12:11PM
923
March 06, 2012 12:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.