Create a new column based on duplicates of another column

I am new to SQL. Assume there is a table with few columns e.g.,
There are duplicates in id column.