Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Querys sql

Language: Layout:
- ] Show input
Absolute running time: 0.44 sec, cpu time: 0.18 sec, memory peak: 7 Mb, absolute service time: 0,55 sec 
fork mode |  history  | discussion
select tableOne, count()/(select count() from arbol) as probabilidad from arbol where tableOne in(select distinct tableOne from arbol) group by tableOne;
select tableOne, tableTwo, count()/(select count() from arbol) as Probabilidad from arbol where tableOne in(select distinct tableOne from arbol) and tableTwo in(select distinct tableTwo from arbol) group by tableOne, tableOne order by tableOne, tableTwo;

    
                
λ
.NET NoSQL database for rapid development