如何有效地选择所有重复项

I want to select all rows that have a value that already exists in the table. I did not find a better solution thanI want to select all rows that have a value tha