0

how to display only similar records from a table

the data rows which are repeated only

14th Aug 2016, 7:09 AM
rahul chanda
rahul chanda - avatar
7 Respostas
+ 2
Try using 'not distinct all_columns from table'
14th Aug 2016, 12:47 PM
J Arun Kumar
0
use distinct keyword
14th Aug 2016, 7:26 AM
Dipak Wani
0
Using NOT Distinct will work
16th Aug 2016, 9:28 PM
Haaris Ali
Haaris Ali - avatar
- 1
you know right?
14th Aug 2016, 7:32 AM
Bagus Ari
Bagus Ari - avatar
- 1
what?
14th Aug 2016, 7:33 AM
Bagus Ari
Bagus Ari - avatar
- 1
if a table contains d duplicate values I need to display only those duplicate values
14th Aug 2016, 7:50 AM
rahul chanda
rahul chanda - avatar
- 1
distinct returns only one similar record even if the same record is duplicated in d table multiple times
14th Aug 2016, 7:53 AM
rahul chanda
rahul chanda - avatar