Re: Is there something equivalent to Unix "uniq" in Oracle?

From: Connell <news_NOSPAM_at_mcmenamin.me.uk>
Date: Sat, 12 Jul 2003 10:57:49 +0100
Message-ID: <3f0fdb9d$0$56606$bed64819@pubnews.gradwell.net>

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:m4hvgvk875jjfaaf61atpcscohg4m0a13f_at_4ax.com...
> On 11 Jul 2003 23:53:22 -0700, ramon_at_conexus.net (Ramon F Herrera)
> wrote:
>
> >Does Oracle have a modifier or function equivalent
> >to the "uniq" Unix command?
> >
> >I need to do something like this across the Internet:
> >
> >SELECT id FROM hugetable ORDER BY id;
> >
> >I know that there are lots of repeated values and
> >I am trying to reduce the network traffic.
> >
> >TIA,
> >
> >-Ramon F. Herrera
>
>
> distinct
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

select distinct(id) from hugetable order by id; Received on Sat Jul 12 2003 - 04:57:49 CDT