|
View previous topic :: View next topic
|
| Author |
Message |
die7nadal
Active User
Joined: 23 Mar 2005
Posts: 156
|
|
|
|
I have a file FB 2 Bytes.
I need to sort it in the 1st column and if there are any dups, retain only the row that has the least value in the 2nd column.
Right now what I plan to do is Sort in ASC order column 1 and 2,
Then in the next Step Sort only the 1st column with SUM FIELDS=NONE,EQUALS option to get,
Using SYNCSORT I want to know if there is a better method than this. |
|
| Back to top |
|
 |
DavidatK
Active Member
Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA
|
|
|
|
I think you got it. 
Dave |
|
| Back to top |
|
|
jasorn
Warnings : 1
Active User
Joined: 12 Jul 2006
Posts: 191
Location: USA
|
|
|
|
| DavidatK wrote: |
I think you got it.
Dave |
That's the only way I know. |
|
| Back to top |
|
|
sril.krishy
Active User
Joined: 30 Jul 2005
Posts: 183
Location: hyderabad
|
|
|
|
Hi,
You can use the SELECT clause with FIRST option.This is the other way only.
Thank you
Krishy |
|
| Back to top |
|
|
|
|
