>hi all,
>
>

>create cusor thankUT ( iresidentid I , nsql I )
>
>*first
>insert into thankUt ( iresidentid  , nsql  ) values ( 1 , 1 )
>insert into thankUt ( iresidentid  , nsql  ) values ( 1 , 7 )
>
>
>* second
>insert into thankUt ( iresidentid  , nsql  ) values ( 2 , 14)
>insert into thankUt ( iresidentid  , nsql  ) values ( 2 , 14 )
>insert into thankUt ( iresidentid  , nsql  ) values ( 2 , 8 )
>insert into thankUt ( iresidentid  , nsql  ) values ( 2 , 7 )
>
>

>
>i want a sql to have 2 in first exemple
>i want a sql to have 3 in the second exemple
>
>thank in advance

select count(distinct nsql  ) ;
	from thankUT