Given a table named MyTab that contains a column named TelephoneNumber that
has 8 instances of 123-4567 in it and 3 instances of 444- in it:
select distinct(TelephoneNumber) from MyTab
will give you each of the phone numbers, once each, i.e. the result will be:
123-4567
444-
This query:
"Jan Blomqvist" <[EMAIL PROTECTED]> wrote:
> Hi! Is there a select statement , wich works like the command uniq in unix,
> if I shall list a table with a column wich for example is telephonenumber
> and the same number occurs like 1000 times, and I wan,t i present just once
> and also the count how
you can do something like:
select phone_number, count(1)
from your_table_name_here
group by phone_number
> -Original Message-
> From: Jan Blomqvist [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 15, 2004 8:27 AM
> To: [EMAIL PROTECTED]
> Subject: any select statement like uniq in unix
>
