Posted By: snake (keeping on the sunny side) on 'CZdatabases'
Title:     Select count distinct
Date:      Tue Jan  4 00:40:46 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