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
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 |
|
|
|