Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
[SQLite] Show duplicate columns
rodrigosantosbr
Jan 8th, 2019
139
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
SQL
0.14 KB
| None
|
0
0
raw
download
clone
embed
print
report
SELECT
cnpj
,
COUNT
(
*
)
c
FROM
pessoajuridica
GROUP
BY
cnpj
HAVING
c
>
1
;
SELECT
cpf
,
COUNT
(
*
)
c
FROM
pessoafisica
GROUP
BY
cpf
HAVING
c
>
1
;
Advertisement
Add Comment
Please,
Sign In
to add comment
Public Pastes
Untitled
54 min ago | 0.29 KB
December smells like money
CSS | 54 min ago | 0.29 KB
Untitled
1 hour ago | 62.47 KB
Kibana / Custom Visualization via Vega - Stre...
JSON | 3 hours ago | 1.82 KB
Kibana / Custom Visualization via Vega - Pie
JSON | 3 hours ago | 1.44 KB
Untitled
3 hours ago | 12.01 KB
Kibana / Custom Visualization via Vega - Pare...
JSON | 3 hours ago | 1.67 KB
Untitled
3 hours ago | 62.53 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!