Select duplicate data from a table

From: Boubaker Idir <boubaker.idir_at_gmail.com>
Date: Fri, 23 Mar 2018 09:55:10 -0700 (PDT)
Message-ID: <883cfbc7-6cdb-470b-a393-145a4980e5e8_at_googlegroups.com>

[Quoted] Hello guys, I can't find the right mysql request to select duplicate data for my case: I have a table "myTable" and I have this data: packetid, bssid, rssi One packetid have more than one bssid and more than one rssi.

I want to select all packetids without the packetids that have more than 3 similar bssid, similar bssid between the packetids.

packetid1 = bssid1,bssid2,bssid3,bssid4
packetid2 = bssid2,bssid3,bssid4    ====> eliminate this packetid from selection
Packetid3 = bssid1,bssid2  ====> eliminate this packetid
packetid4 = bssid1,bssid2,bssid4 ====> eliminate this packetid
packetid5 = bssid1,bssid2,bssid5 ====> save this packetid to selection

Thank you so much
regards Received on Fri Mar 23 2018 - 17:55:10 CET