Posted By: Trpaslik (syn Krale pod Horou) on 'CZdatabases'
Title:     Re: Select count distinct
Date:      Tue Jan  4 15:32:06 2000

> Hello all!
> 
> Zajimalo by mne, jak se da zjistit pocet ruznych (select distinct *) radek a
> spocitat jejich pocet (select count(*)). Ovsem oboje dohromady. Databaze 
> postgres 6.5.2.
> 
> Dokazu to obejit pres pomocnou tabulku tablex:
>  select distinct * into table tablex from table1 ;
>  select count(*) from tablex ;
>  drop table tablex ;
> ale kazdy uzna, ze to neni ono...
> 
> Neporadi nekdo?
> 
> snake

   Jestli ti zalezi pouze na jedne polozce, muzes to zkusit zgrupovat:

   SELECT   count(*)
   FROM     table
   GROUP BY column

   Taky by to mohlo jit vnorenym selectem, ale to si nejsem jistej,
patrne to zalezi na konkretni implementaci:

   SELECT count(*)
   FROM   (SELECT distinct *
           FROM   table)

   Vyzkousej a uvidis.
                                                        Trpaslik

        With the lights out, it's less dangerous...        Kurt Cobain