Maybe this is a stupid question but i'm kind of stuck on it

 

i have this big list with 2 column's (actualy there more but that's not the problem)

 

Document   //     user

 

000001               user1

000001               user1

000001               user1

000002               user2

000002               user2

000003               user3

000003               user1

000004               user1

 

this is SQL and i made a distinct view to group them on document

 

SELECT DISTINCT TOP 100 PERCENT h_document, h_user
FROM         dbo.hissto

 

this gives me:

the formula works but the info in the return is still with double document numbers i'm afraid

 

but again thank you for the effort of making the replay!!

 

Greetings

 

Tom

 

Tested this and added some info and right now i have this:

 

SELECT     TOP 100 PERCENT x.h_document, x.h_user, x.RecCount
FROM         (SELECT     h_document, h_user, COUNT(*) AS RecCount
                       FROM          dbo.hissto
                       GROUP BY h_document, h_user) x INNER JOIN
                          (SELECT     h_document, MIN(RecCount) AS RecCount
                            FROM          (SELECT     h_document, h_user, COUNT(*) AS RecCount
                                                    FROM          dbo.hissto
                                                    GROUP BY h_document, h_user) y
                            GROUP BY h_document) z ON x.RecCount = z.RecCount AND x.h_document = z.h_document
WHERE     (SUBSTRING(x.h_document, 1, 1) IN ('F', 'K'))
ORDER BY x.h_document

 

and works great

 

 

tnx for the feedback and the help

 

Tom