selecting rows with one same and one different column

selecting rows with one same and one different column

References

Reference NO 1

http://stackoverflow.com/questions/1408141/sql-selecting-rows-where-one-columns-value-is-common-across-another-criteria-co

Reference NO 2

http://stackoverflow.com/questions/15191238/selecting-rows-with-one-same-and-one-different-column

Reference NO 3

http://stackoverflow.com/questions/5422485/select-from-same-column-possible-different-row-in-one-select-statement-using-j

Reference NO 4

http://stackoverflow.com/questions/15755474/several-rows-with-exact-same-values-but-only-one-column-returns-different-value

Reference NO 5

http://stackoverflow.com/questions/16049635/in-mysql-how-do-i-select-only-every-row-that-has-the-same-value-in-one-column-b

Reference NO 6

#EANF#

Reference NO 7

#EANF#

Reference NO 8

#EANF#