how to display only similar records from a table

Question

the data rows which are repeated only

Answer 1

Try using 'not distinct all_columns from table'

Answer 2

use distinct keyword

Answer 3

Using NOT Distinct will work

Answer 4

you know right?

Answer 5

what?

Answer 6

if a table contains d duplicate values I need to display only those duplicate values

Answer 7

distinct returns only one similar record even if the same record is duplicated in d table multiple times