Re: distinct function syntax question
Andre da Silva Nazare wrote:
>
> Try using this :
>
> select 1
> from table_x
> group by col1,col2 into temp temp_table;>
> select count(*) from temp table;
Couldn't it be this shorter way ?
select count(*)
from table_x
group by col1,col2;
Gert
--
Gert Brinkmann email: gbrinkmann@dimedis.de
Software Development tel: 0221/921260-0
dimedis GmbH fax: -99
Habsburgerring 2-12 http://www.dimedis.de
50674 Koeln http://www.RealTimeImage.de