[GNC] Trading accounts

[Wm Tarr]

I don't think you can do it in gnc but here is some SQL that does it

===

with m_cnt as (

select mnemonic, count(*) as cnt

from commodities

group by mnemonic

having cnt > 1

)

select namespace, mnemonic

from commodities

where mnemonic in (select mnemonic from m_cnt)

;


===

Wm

On 2026-08-10 01:36, Fred Tydeman wrote:
>
> Anyone know of a way to find stocks in more than one Namespace?
>
>