|
View previous topic :: View next topic
|
| Author |
Message |
biswadeepghosh
New User
Joined: 03 Jan 2008
Posts: 14
Location: Pune
|
|
|
|
Can anyone suggest me how to use the UNIQUE command on multiple columns ?
Thanks in advance |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Please post an example of your "input" data values and what you want "unique" to accomplish as "output". |
|
| Back to top |
|
|
biswadeepghosh
New User
Joined: 03 Jan 2008
Posts: 14
Location: Pune
|
|
|
|
Thanks
I need only on row to be displayed for a set of values for all the feilds.
DATA_GRP_ID | VERSION | ACCESS_ID | FUNCTION | QUAL
CD020 01 CA010 R UNIQUE
CD030 12 CA010 R UNIQUE
CD232 01 CAD10 R UNIQUE
CD020 01 CA010 R UNIQUE
CD480 03 CA01W R CLOSE
CD020 01 CA010 R UNIQUE
CD030 12 CA010 R UNIQUE
CD020 01 CA010 R UNIQUE
CD232 01 CAD10 R UNIQUE |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I need only on row to be displayed for a set of values for all the feilds. |
Sorry, but i do not understand what this tells me. If you want "only one row" what would it contain?
Is there a reason the .jpg is posted twice?
Once your requirement is understood, we may be able to offer some usable suggestions. |
|
| Back to top |
|
|
|
|
