|
View previous topic :: View next topic
|
| Author |
Message |
hiravibk
Warnings : 1
Active User
Joined: 14 Dec 2008
Posts: 107
Location: India
|
|
|
|
Hi,
Is there a way i can fetch duplicates of a column with only part of the value.
Eg: I have a column client_id which is of length 10 in BANKING table. I want to do a select on this table for all duplicate client_id on 1 to 9 characters only.
In BANKING table:
| Code: |
CLIENT_ID
========
0000000091
0000000093
0000000095
0000000035
0000000065
|
My query must return 0000000091,0000000093 and 0000000095. Please help. Thanks in Advance |
|
| Back to top |
|
 |
Pandora-Box
Global Moderator
.jpg)
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
Unload the data and sort it to get duplicates alone
or find the values for which duplicates exist and the select the data from table using like |
|
| Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
| Back to top |
|
|
hiravibk
Warnings : 1
Active User
Joined: 14 Dec 2008
Posts: 107
Location: India
|
|
|
|
I need only duplicates from a query. I thought LIKE was for partial search only. |
|
| Back to top |
|
|
|
|
