How to Delete Duplicate Record ?
or what is the query for duplicate record for make table query.
or what is the query for single NO table?
Sample date
my question is to make table of duplicate NO field.?
NO SALUTATION S_NAME FIRST_NAME LAST_NAME
12 Mr SURESH R SURESH R
12 Mr. SNAGABVSHAN S SNAGABVSHAN S
45 Mr MAHESH N MAHESH N
12 Mr IVANDSOOZA B IVANDSOOZA B
12 Mr. KALEEMULLAKHAN EKALEEMULLAKHAN E
33 Mr NEMACHANRA S NEMACHANRA S
5 Mr MANJU B MANJU B
6 Mrs GANGALAKSHMMA CGANGALAKSHMMA C
6 Mr EASANOORUSHEED SEASANOORUSHEED S
6 Mr. NAGESH B NAGESH B
77 Mr. NARAYANA N NARAYANA N
5 Mr. KESHAV K KESHAV K
help me out
or what is the query for duplicate record for make table query.
or what is the query for single NO table?
Sample date
my question is to make table of duplicate NO field.?
NO SALUTATION S_NAME FIRST_NAME LAST_NAME
12 Mr SURESH R SURESH R
12 Mr. SNAGABVSHAN S SNAGABVSHAN S
45 Mr MAHESH N MAHESH N
12 Mr IVANDSOOZA B IVANDSOOZA B
12 Mr. KALEEMULLAKHAN EKALEEMULLAKHAN E
33 Mr NEMACHANRA S NEMACHANRA S
5 Mr MANJU B MANJU B
6 Mrs GANGALAKSHMMA CGANGALAKSHMMA C
6 Mr EASANOORUSHEED SEASANOORUSHEED S
6 Mr. NAGESH B NAGESH B
77 Mr. NARAYANA N NARAYANA N
5 Mr. KESHAV K KESHAV K
help me out
