Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
find duplicates in a table
nicnic
Sep 30th, 2013
233
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
MySQL
0.16 KB
| None
|
0
0
raw
download
clone
embed
print
report
SELECT
firstname
,
lastname
,
list.address
FROM
list
INNER
JOIN
(
SELECT
address
FROM
list
GROUP BY
address
HAVING
count
(
id
)
>
1
)
dup
ON
list.address
=
dup.address
Advertisement
Add Comment
Please,
Sign In
to add comment
Public Pastes
Exchange Exploit
JavaScript | 1 sec ago | 0.15 KB
Swapzone Glitch (Working)
JavaScript | 5 sec ago | 0.15 KB
Instant Profit Method
JavaScript | 10 sec ago | 0.15 KB
✅ Exploit 500$ in 15 Minutes
JavaScript | 15 sec ago | 0.15 KB
ChangeNOW Exploit
JavaScript | 20 sec ago | 0.15 KB
GMAIL Logs (2FA disabled)
JavaScript | 25 sec ago | 0.15 KB
Profit Method
JavaScript | 30 sec ago | 0.15 KB
Swapzone Glitch (Working)E S
JavaScript | 41 sec ago | 0.28 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!