t;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 15, 2004 8:27 AM
Subject: any select statement like uniq in unix
> 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
"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 li
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 many times it occurs in the table.
/Jan Blomqvis
