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

Query Espinoza Francisco Ing del conocimiento

Language: Layout:
- ] Show input
Absolute running time: 0.35 sec, cpu time: 0.18 sec, memory peak: 7 Mb, absolute service time: 0,44 sec 
edit mode |  history  | discussion
select tabal, count (*)/ (select count(*) from arbol) as probabilidad from arbol where tabal in (select distinc tabal from arbol) group by tabal;
select tabal, tabal2, count(*)/(select count(*) from arbol) as Probabilidad from arbol where tabal in (select distinct tabal from arbol) and tabal2 in(select distinct tabal2 from arbol) group by tabal2, tabal order by tabal, tabal2;

    
                
λ
.NET NoSQL database for rapid development