In an unkeyed table, how do I find exact duplicates?If there are only a few columns, I can do aselect count i by col1, col2 …colnIs there a less verbose way to do this? Especially if there are manycolumns to type.
group table AttilaOn 3 Dec 2008, at 20:52, Dal Mon wrote:>> In an unkeyed table, how do I find exact duplicates?>> If there are only a few columns, I can do a> select count i by col1, col2 …coln>> Is there a less verbose way to do this? Especially if there are many> columns to type.>> >
So if I wanted to get the dups onlygt:group table(key gt) where [1 < each[count] value gt]thanks!On Dec 3, 3:56?pm, Attila Vrabecz <attila.vrab…> wrote:> group table> ? ?Attila>> On 3 Dec 2008, at 20:52, Dal Mon <dalae…> wrote:>>>> > In an unkeyed table, how do I find exact duplicates?>> > If there are only a few columns, I can do a> > select count i by col1, col2 …coln>> > Is there a less verbose way to do this? ?Especially if there are many> > columns to type.>></dalae…></attila.vrab…>
where 1 wrote:>> So if I wanted to get the dups only>> gt:group table> (key gt) where [1 < each[count] value gt]>> thanks!>> On Dec 3, 3:56 pm, Attila Vrabecz <attila.vrab…> wrote:>> group table>> Attila>>>> On 3 Dec 2008, at 20:52, Dal Mon <dalae…> wrote:>>>>>>>> > In an unkeyed table, how do I find exact duplicates?>>>> > If there are only a few columns, I can do a>> > select count i by col1, col2 …coln>>>> > Is there a less verbose way to do this? Especially if there are many>> > columns to type.>>>>> >></dalae…></attila.vrab…>