Posted By: ceny (C~eny) on 'CZdatabases'
Title:     Re: Duplicity
Date:      Tue Oct 29 16:48:58 2002

co treba

Select ID, Count(neco) From t1
Where Count(neco) > 1
Group By ID

 - nevim jestli zrovna Oracle, ale myslim ze na Sybase by to melo byt

Select ID, Count(neco) as Pocet From t1
Where Pocet > 1
Group By ID

jo a za sloupecek [neco] dosad nejaky dalsi sloupec ;-)

> Pokud byste chteli vypsat vsechna takova id sloupcu, ktere maji v konkretnim
> sloupci stejnou hodnotu vic jak jednou, jak byste to udelali?
> Nejake exist a in by se tam nemelo objevit, sice to bezi na oracle, ale jde
> o desetitisice radku, takze treba

v
Ceny