How to select two rows that share a column

select rows where column contains same data in more than one record
sql select rows with same values in two column
how to select all rows which have same value in some column
sql query to select record having same id but different value in two columns
sql select rows with different values in one column
sql select duplicate rows based on one column
sql select rows with same values in one column
sql select where more than one occurrence