how to get duplicate values from a mysql query on input of array?

Question

I have a query for which I am giving a list of items as input, the item list contains duplicate values.

select * from ITEM  where ITEM_NUMBER in ('15','41', '15','41');

the resulting output contains 2 rows with

ITEM_NUMBER 15

and

41

I want a query, which returns 4 rows with duplicate values.

Use set collection to store values. Then iterate set create query text — Sumesh TG
– Sumesh TG, Commented Feb 9, 2018 at 13:30

highnelly · Accepted Answer · 2018-02-09 14:41:17Z

0

This is one option using join:

select *
from items a
join (select item_number
      from items  
      group by  item_number
      having count(*) > 1) b
on a.item_number = b.item_number;

Adapted from an answer in this link: Show all duplicated rows

answered Feb 9, 2018 at 14:41

highnelly

92 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrew Edwards · Accepted Answer · 2018-02-09 15:34:31Z

0

Here's a solution using UNION and TOP

select * from 
(select top 2 * from item where item_number=15) 
union all select * from 
(select top 2 * from item where item_number=41);

answered Feb 9, 2018 at 15:34

Andrew Edwards

655 bronze badges

Collectives™ on Stack Overflow

how to get duplicate values from a mysql query on input of array?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related