tælle unikke forkomster

Not quite sure what your after but if you want to see how many unique (DISTINCT) CPR there are in your table then something like.

SELECT Count(*) AS A
FROM (SELECT DISTINCT CPR
FROM YourTable)

Hi Terry

Sorry but I can't manage to fill the abowe in my query correct.
The information that i got is as follow ;o)

Tabel name : 2009
Fields form tabel
Perskat: the values is 3 digits e.g 110 - 115 - 120 ect.
Cpr: xxxxxxxxxx
Periode: 200909 - 200903 ect.

I need to be able to select the periode.
The I need to be able to count the unic cpr numbers for each Perskat

Hope this cleari fies - and this time I'm able to sent a cpoy in a ano ;o) - if you need it

Yes can you send a copy please?
ekspertenATsanthell.dk

AT = @

will do :o)

Tks

/Ida

Have you sent your dB?

yeps

I havent received anything. Please check the eamil and alos try ZIPPING the file

I think its comming now :o)

I have zip' the file and renamed the db file to txt

otherwise try to sent me a mail to
ida.nielsen(a)maersk.com

I have received it now

You alreday have an answer Skrevet fre. d. 02. oktober 2009 kl. 17:03:21| #1

:o)

whats te status Ida?

thanks