como verificar registros duplicados no sql postgresql

Good Job answered on October 26, 2021 Popularity 1/10 Helpfulness 1/10

Comment

SELECT year, COUNT(id)
FROM YOUR_TABLE
GROUP BY year
HAVING COUNT(id) > 1
ORDER BY COUNT(id);

Popularity 1/10 Helpfulness 1/10 Language sql

Source: qastack.com.br

Tags: postgresql sql

Link to this answer
Share Copy Link

Contributed on Oct 26 2021

Good Job

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.